Re: DATA-INTO where number of records not known

Multiple options.

I'm guessing that %Handler doesn't work because the repeating element is not at the top level? In that case you can use the path= option to drill down to the repeating level and use %Handler that way. If you need the earlier non repeating stuff then you can do that with a separate pass of DATA-INTO.

I could offer other suggestions if you could give us a hint or two as to what the json looks like. It really depends on the document and whereabouts the unknown number of repeats occurs.

To directly answer your question though - no - the count will not be set correctly. DATA-INTO would error out at the point that the limit was exceeded, unless you specified allowextra=yes in which case it should complete but the count would be set to the maximum array size. Easy enough to test this ... just code an example with a tiny number of elements.

On Dec 10, 2020, at 5:01 PM, Don Brown via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

(Sorry, not sure if this is should be the RPG list only or the Midrange
list)

We are using data-into with YAJLINTO to process a json file we retrieve
from an external site using a web service.

The web service does not provide any options as to controlling the number
of records to be returned.

The json returned does not have an element for the number of records
provided.

If I put a count at the highest level will this be set correctly if the
number of records retrieved exceeds the array size ? And if yes how do I
then process the records past that point ?

I don't think the %handler option helps - well the way I read the doco it
wont.

How do I either check how many records have been returned or process a
json string that exceeds the number of elements in my receiving array ?

Thanks for all suggestions

Don


--
This email has been scanned for computer viruses. Although MSD has taken reasonable precautions to ensure no viruses are present in this email, MSD cannot accept responsibility for any loss or damage arising from the use of this email or attachments..
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com