Creating a library from web service based JSON data in Enterprise Guide

Chris_M — Wed, 12 Feb 2020 01:09:28 GMT

Some of the information that we use is being moved from oracle tables to web services. We accessed the oracle tables through servers>local>libraries that were set up with code that was run when we started SAS. We are using EG version 7.3.

At this point I am only trying to set up a library for a list of account numbers and parcel numbers:

1 55425 16109110079
2 55426 16109110078
3 55427 16104413031
4 55464 16109501001
5 55465 16109501001

Running the following code will generate a data table and a report in the process flow. The first 5 lines of this table are above. (I am not a programmer and I have a partial understanding of what each step does. I put them together from examples and by trial and error)

filename mymap temp;

filename resp temp;
filename hdrs temp;
filename parcels temp;
filename map temp;
 

data _null_;
infile datalines;
file mymap;
input;
put _infile_;
datalines;
{
  "DATASETS": [
    {
      "DSNAME": "sp_to_parcel",
      "TABLEPATH": "/root",
      "VARIABLES": [
        {
          "NAME": "ordinal_root",
          "TYPE": "ORDINAL",
          "PATH": "/root"
        },
        {

          "NAME": "ServicePoint",
          "TYPE": "CHARACTER",
          "PATH": "/root/ServicePoint"
        },
        {
          "NAME": "Parcel",
          "TYPE": "CHARACTER",
          "PATH": "/root/Parcel"
        }
      ]
    }
  ]
}
;
run;


proc http 

 url="https://isddev.blah.blah.com/SASWebServiceDemo/api/ServicePoint"
 method= "GET"
 out=resp;

headers
   "Authorization"="Bearer xxxxxx";

 run;

 libname parcels JSON fileref='resp' map=mymap;

data results_out;
set parcels.sp_to_parcel;
run;
proc datasets library=parcels; run;

If I add the code up to the libname statement into the code that runs when I start SAS it will create an entry for Library>Parcels> SP_TO_PARCEL but when I click on it I get the error "Source array was not long enough. Check srcindex and length, and the array's lower bounds"

Thanks in advance for your help

Chris

topic Creating a library from web service based JSON data in Enterprise Guide in SAS Enterprise Guide

Creating a library from web service based JSON data in Enterprise Guide