× 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.


  1.  Home
  2. RPG400-L
  3. June 2020

json - data-into question

I have the following json string:

{
  "success":true,
  "terms":"https:\/\/currencylayer.com\/terms",
  "privacy":"https:\/\/currencylayer.com\/privacy",
  "timestamp":1591634166,
  "source":"USD",
  "quotes":{
    "USDEUR":0.885598,
    "USDGBP":0.78826,
    "USDCAD":1.33873,
    "USDPLN":3.92377
  }
}


The issue i am having is "quotes". The label can change based on what you are looking for. My code:

d mydata          ds                  qualified
d  success                      50a
d  terms                       150a
d  timestamp                    50a
d  quotes                             likeds(qds) dim(10)

d qds             ds                  qualified
d  usdeur                       50a


data-into myData %DATA(myjson:
    'case=any countprefix=num_  allowmissing=yes allowextra=yes')
%PARSER('YAJLINTO');


only works if i know the qualified field name (usdeur for example).

Can i use this techique to read this json into my ds?


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.