Hello
I'm using Apex 23.1 over a 21c DB and it’s the first time using the process using “Invoke API” as type functionality.
The situations is this:
I have an API with a POST method, which receives 16 items (15 for input and 1 for output). This API allow sending one record at a time. Considering that I need to send about 80 records, I’ve build an IG that show all the records formatted as they are required by the API
I have also created a REST data source defining the API and the structure of the JSON message, including all the items of the message
After that, I set a process with type “Invoke API”, which use as “Editable region” the IG, and mapped all the values from the IG to the REST API Data Source and tested successfully the API interface
According to this, I have the followings “problems”
- As the IG is based on a DB query which retrieve and format the values as required by the API, all the records are signed as not edited nor inserted, so the only way I’ve found to force the processing of the record is to edit manually a record, which is OK the test the API, but is a no way if it should be done with all the 80 records on a daily basis.
- Trying to create a workaround, I do created a temp table which receives the query data, but I didn’t figure out how to “insert” the records on the IG in order to mark them as new and force the process execution
So, the main issue that I've is how to sign the IG records as modified and trigger it process by the "Invoke Api" process.
I wonder if anyone has any suggestion about how to handle this situation.
Thanks in advance