WriteStage Reference of CSV File Doesn't Exist Out of Loop
I've an orchestration integration. Our target to post several transactions at ERP system one by one through loop and accumulate all responses into csv file then attach the file to the response.
For this, we did the following:
1. Get records from database
2. Construct for-loop to go through these records.
3. Within the for-loop, we consume REST API to create some transactions at Oracle Fusion.
4. The response from the REST API is appended to StageWrite activity of csv.
5. Out of the loop, we need to send the generated csv file at the response of the integration.
The issue that when we try at the mapper of the integration response to map WriteStage Reference to Attachment of the response, WriteStage Reference doesn't exist. It exists only within the loop.