Hello,
I am making my first steps with json file and I need help.
First, I am connecting to an oracle db to read a precise table which is brought into the dataset test.
Here's what it look like
JSON_FORMAT
"{""contacts"":[{""firstName"":""Rokaya"",""lastName"":""Bablabla"",...""}]}"
"{""contacts"":[{""firstName"":""Nazalene"",""lastName"":""Bablabla"",...""}]}"
I have retrieve a lot of information for safety purpose. I would like to read / import each fields such as firstName, lastName and so on. Then I will replace all the email , agentEmail and managerEmail for my email , for testing purpose.
Then from that point, I need to reproduce the original file above as it was before but with the 3 email fields updated.
After that, I will take this file save it on our server. Thereafter, I will develop the SAS code to send the information to an API web server.
I'm confused.
Sounds like there is a field JSON_FORMAT in your database. What is the column type of that field? Is it a blob or some-such which actually stores a JSON file? Or is it a varchar which has JSON (JSONL?) text in it?
How far have you gotten? Do you have the SAS code to connect to the oracle database and query for the JSON_FORMAT column and write a SAS dataset?
If that code works, can you post the code, and post the results of running PROC PRINT on a few records?
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.