Fantastic!
In this case, the data in question represents things like parts of an address or phone number. This particular API is consolidating orders coming from multiple sources (i.e. Amazon, eBay, etc.) The Amazon order data contains "null" instead of blanks , while the eBay order data will contain "".
Consistency would be nice... but this will work just fine.
Thank you sir!
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Wednesday, June 19, 2019 3:31 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Data-Into (YAJLINTO) question
Greg,
You can configure YAJLINTO to put any value you like into a null field by specifying the "value_null" option to the parser. To make it blank, just pass an empty string:
%PARSER('YAJLINTO': '{ "document_name": "doc", "value_null": "" }');
As for how this is "normally" handled, its normally handled by mapping a string of *NULL to the field. The problem with blanks is that you can't tell the difference between a field that was set to null, and a field that was set to blank, and in many applications the difference does matter. Since it's not possible for a DATA-INTO parser to set a field's null indicator, it passes the special value of *NULL that your code can look for.
But, if you want something else, such as blanks or zeroes, all you have to do is specify the value_null option, as shown above, and specify the appropriate string.
Good luck
-SK
On 6/19/2019 2:19 PM, Greg Wilburn wrote:
I apologize if this question is not appropriate for this mailing list...
I'm using YAJLINTO to load JSON into my data structure... In some of the elements I'm gathering, the element literally contains "null". Sometimes it contains "". YAJLINTO converts this to "*NULL" (that ends up in my DS fields).
Example:
"SellerOrderID": null,
In my DS field SellerOrderID (char(128)) contains *NULL
Since I'm using mostly all character definitions, I was wondering how to handle this.
Is there option with YAJLINTO to convert "null" to blank instead of "*NULL", or do I need to look for "*NULL" in each field before loading the data into my database files?
How is this normally handled?
Thx,
Greg
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
