How can we store the JSON payload in Staging/ Source Table?

Ankita9
Tera Contributor

Hi All,

 

How can we store the JSON payload in Staging/ Source Table?

 

TIA

6 REPLIES 6

Mike_R
Kilo Patron
Kilo Patron

Is the staging table already created and being used, or are you trying to create a staging table?

Ankita9
Tera Contributor

Staging table is already created, I want to store the JSON Payload as it is passed in some field on the Staging Table.

You can create a new field on the staging table. Then update your API body to pass the entire JSON to that field.

Ankita9
Tera Contributor

Hi Mike,

 

Thanks for your response.

How to achieve this "Then update your API body to pass the entire JSON to that field?"
Note : I'm working on REST Import Set API.