Load JSON response from file/web service to Postgres table varchar/jsonb field : Portal

Start a new topic

Load JSON response from file/web service to Postgres table varchar/jsonb field

Nelrick. rodrigues

started a topic 13 days ago

We are using the Semarchy xDI version 2023.1.7

We have a specific requirement to read the entire JSON payload from either a webservice or file and load it into a varchar/jsonb column in PostgreSQL database.

I checked the string_content property field for JSON metadata as per documentation https://www.semarchy.com/doc/semarchy-xdi/xdi/latest/Components/base/json/json-property-fields.html, however this property is unavailable for 2023.1.7 version.

Is there a workaround since we have both cases of reading webservice and JSON input file and loading to database column.