Automated API to export spreadsheet on negotiation supplier response

Client used use APEX custom application to supplier upload negotiation response and integrated it to Fusion to create the response and generated the spreadsheet csv file in APEX. However, they face an issue where the supplier needs to export spreadsheet in Fusion first, otherwise the internal line id’s generated in the csv file is incorrect.

1. Supplier uploads RFP (excel file contain supplier response price) in APEX, and clicks “Confirm and Submit”
2. Supplier opens the response in Fusion and click on “Export Spreadsheet”. – Additional step
3. Supplier downloads ZIP file from APEX
4. Supplier Imports the zip file with response prices in Oracle and clicks “Submit”