Code:
- data structure:
- dcl-ds return_array Qualified;
- dcl-ds articles dim(999) ;
- id int(10);
- itemNumber char(15);
- assetId char(15);
- userId char(64);
- vinNumber char(18);
- articleId int(10);
- systemId int(5);
- typeId int(5);
- articleSecondaryId char(15);
- description char(30);
- count_locations int(5) ;
- dcl-ds locations Dim(20);
- locationId int(10);
- locationLabel char(64);
- siteId char(5);
- ccu char(5);
- typeId char(5);
- systemId char(5);
- dcl-ds timestamp ;
- date char(26);
- timezone_type int(5);
- timezone char(64);
- end-ds timestamp;
- serialNumber char(10);
- shopOrderNumber char(10);
- end-ds locations;
- end-ds articles;
- end-ds return_array;
-
-
- DATA-INTO return_array %Data( retdata :
- 'doc=string case=any ' +
- 'allowextra=yes countprefix=count_')
- %Parser('YAJLLIB181/YAJLINTO' );
-
-
-
- json data (UNFORMATTED)
-
- {"articles":[{"id":2677,"itemNumber":"12239992","assetId":"","userId":"","vinNumber":"","articleId":2677,"systemId":1,"typeId":1,"articleSecondaryId":"12239992","description":"HOOK CHAIN UB","locations":[{"locationId":970,"locationLabel":"615 : 7-7 : 2-0","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2017-05-30 08:55:05.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":958,"locationLabel":"615 : 7-5 : 2-0","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2017-05-30 08:55:05.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":2469,"locationLabel":"615 : WW : 4 - 1","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-07-21 03:48:10.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":4242,"locationLabel":"NIGHT TRAIN RACK","siteId":null,"ccu":null,"typeId":2,"systemId":1,"timestamp":{"date":"2018-10-01 22:47:11.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":2470,"locationLabel":"615 : WW : 4 - 2","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-10-11 03:15:22.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":6996,"locationLabel":"LAB 1B","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-10-29 14:27:52.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null}]},{"id":3973,"itemNumber":"12240867","assetId":"","userId":"","vinNumber":"","articleId":3973,"systemId":1,"typeId":1,"articleSecondaryId":"12240867","description":"LOCKSTRIKE, NUT","locations":[{"locationId":930,"locationLabel":"615 : 7-3 : 1-0","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-02-15 17:52:36.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null}]},{"id":4437,"itemNumber":"12247250","assetId":"","userId":"","vinNumber":"","articleId":4437,"systemId":1,"typeId":1,"articleSecondaryId":"12247250","description":"LATCH,NGL ROTARY","locations":[{"locationId":4834,"locationLabel":"636 : A - 6 : 4 - 2","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-07-02 08:58:57.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":4814,"locationLabel":"636 : A - 5 : 5 - 2","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-07-02 09:53:11.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":4835,"locationLabel":"636 : A - 6 : 5 - 2","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-07-02 10:15:48.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":935,"locationLabel":"615 : 7-1 : 3-0","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-09-07 04:53:59.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":6911,"locationLabel":"33AB00101","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-07-17 11:54:42.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":4870,"locationLabel":"636 : B - 2 : 2 - 2","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-09-17 20:14:42.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":2503,"locationLabel":"615 : SW : 5 - 2","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-10-08 23:42:03.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null},{"locationId":6996,"locationLabel":"LAB 1B","siteId":null,"ccu":null,"typeId":1,"systemId":1,"timestamp":{"date":"2018-10-29 14:50:43.000000","timezone_type":3,"timezone":"America\/Chicago"},"serialNumber":null,"shopOrderNumber":null}]}]}
-
|
|