how to manipulatge json file

[alepage]

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.

[Quentin]

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?