Re: YAJLGEN and 'Variable' Named Elements

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Hello Stephen,

Sometimes the biggest problem with tools like DATA-INTO and DATA-GEN is 
that not everything works as an RPG data structure. In your case, the 
data structure would have to have a field named "010", which isn't 
allowed in RPG -- YAJL tries to work around this problem by adding the 
YAJL_ prefix, but...

I wonder if it's really smart to use DATA-INTO, for this application?  
If the data doesn't really fit into the format of a data structure, 
maybe it'd be better to just process the JSON by calling the YAJL 
subprocedures?  If forcing the data into an RPG structure is like 
fitting a square peg into a round hole... why not choose another 
alternative?

-SK


On 2/2/2021 4:17 PM, Stephen Piland wrote:
> Another twist I'm uncovering when doing DATA-INTO with number_prefix of YAJL_ in YAJLOPTS...
>
> When executing the DATA-INFO in the example below, it does not add YAJL_ to 010 therefore not loading into the Data structure.  It does add it on an earlier element in the document.  The ONLY difference I can see between the 2 is the example below has the string StoreTotals first then the numeric.  In the trace earlier, it shows YAJL_010 as the name, but it is before the string of StoreTotals.
>
> Maybe this is fixed so I may try and install the latest YAJL library, but maybe that is functioning as designed.
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Stephen Piland
> Sent: Tuesday, February 2, 2021 1:08 PM
> To: rpg400-l@xxxxxxxxxxxxxxxxxx
> Subject: YAJLGEN and 'Variable' Named Elements
>
> I'm not sure if I should go back to the vendor and suggest a change in their schema for this, but...  I used YAJLGEN utility (which is great) to generate the Data structures to be able to DATA-INTO.  A portion of the JSON is below.  My issue is with the "010", which is a Register#, gets generated as YAJL_010 as the name of the Data Structure.  For this JSON, it could contain information for Registers 001 - 999 (YAJL_001 to YAJL_999).  Any ideas on how to not have to create 999 data structures?  I know it would have been great if the vendor created an element named Register and store the value in it.
>
> Thanks!!
>
> "NonTillBasedTenders": {
>                "StoreTotals": {
>                               "CREDIT CARD": {
>                                                           "VISA": [
>                                                                         {
>                                                                          "CurrencyCode": "USD",
>                                                                          "TransactionCount": 1,
>                                                                          "InAmount": 22.99,
>                                                                          "OutAmount": 0
>                                                            }
>                                             ]
>                               }
>                },
>                "010": {
>                              "CREDIT CARD": {
>                                             "VISA": [
>                                                           {
>                                                           "CurrencyCode": "USD",
>                                                           "TransactionCount": 1,
>                                                           "InAmount": 22.99,
>                                                           "OutAmount": 0
>                                                           }
>                                             ]
>                              }
>                }
> }
> --
> 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@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com