One Star

Extractions of columns from a JSON file

Hi Community,

 

I'm really confused that how would i extract the column names from a json file. These columns will then used to a create a table in PostgreSQL. Also, the records associated with these columns will further be used to populate the rows in that particular table. So could you please explain both the scenarios with proper screenshots.

 

For reference, please find the attached JSON file that i extracted from REST web-service.

 

Thanks in advance!

 

Best Regards,

Dipanjan

1 REPLY
Nine Stars

Re: Extractions of columns from a JSON file

tExtractJSONFields and use jsonPath to retrieve data.
Google a bit on how jsonPath query works.