× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I can't figure out how to setup my JSON data structure to produce the following...

[
{
"isAvailable": true,
"itemNumber": "DD03614",
"nextAvailableDate": "2021-10-20T16:58:36.54",
"qtyAvailable": 0
},
{
"isAvailable": true,
"itemNumber": "DD03552",
"nextAvailableDate": "",
"qtyAvailable": 1587
}
]

What's actually produced is:

"item": [
{
"isAvailable": true,
"itemNumber": "DD03552",
"nextAvailableDate": "",
"qtyAvailable": 1587
},
{
"isAvailable": true,
"itemNumber": "DD03614",
"nextAvailableDate": "2021-10-20T16:58:36.54",
"qtyAvailable": 0
}
]
}

I need to remove the "item" name.



I currently have tried several iterations of this (using various %GEN options):
DATA-GEN request %DATA(jsonBody: 'output=clear countprefix=num_')
%GEN('YAJLDTAGEN');

My DS looks like this:

dcl-ds request qualified inz;
num_item int(10) inz;
dcl-ds item dim(5000) inz;
isAvailable ind inz(*off);
itemNumber varchar(15) inz('');
nextAvailableDate varchar(22) inz('');
qtyAvailable int(10) inz(0);
end-ds;
end-ds;


[Logo]<https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.