how to manipulatge json file

alepage — Mon, 20 Feb 2023 21:54:53 GMT

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.

Re: how to manipulatge json file

Quentin — Mon, 20 Feb 2023 22:04:14 GMT

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?

topic how to manipulatge json file in SAS Enterprise Guide

how to manipulatge json file

Re: how to manipulatge json file