Generating response in JSON after the import load gets complete from ETL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-21-2024 06:12 AM
Hi Team,
Kindly suggest me with the below scenario.
1. We have a scripted REST API which brings the data to staging table (Source table).
2. We have IH-ETL to transfer the data to target tables
Currently we are just sending the status code as a response but Now we want to send the complete record details which got inserted from that import load in JSON format as a RESPONSE.
Please guide me how we can achieve this and thanks in advance!
Regards,
Ganesh
- Labels:
-
Architect
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-21-2024 06:57 AM
Hi @Ganeshm1 ,
This should help your case: Import Set API - Goodbye SRAPIs?
Please mark the answer "Correct" or "Helpful", if it helps your case.
Cheers,
Uttkarsh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-21-2024 07:46 AM
Hello @Uttkarsh S : Thank you for you're reply.
In the suggested article, then are using import set API but in my case we are using scripted REST API and its inserting the record to staging table using script. But I want to generate the response based on the target table. This is where I am confused.
Please let me know your thoughts on this.
Regards,
Ganesh
