How can we store the JSON payload in Staging/ Source Table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2022 07:29 AM
Hi All,
How can we store the JSON payload in Staging/ Source Table?
TIA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2022 07:30 AM
Is the staging table already created and being used, or are you trying to create a staging table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2022 07:34 AM
Staging table is already created, I want to store the JSON Payload as it is passed in some field on the Staging Table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2022 07:38 AM
You can create a new field on the staging table. Then update your API body to pass the entire JSON to that field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2022 07:43 AM - edited 11-03-2022 07:44 AM
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.