Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

API POST Rest Call using Interactive Grid

User_WDIT6Sep 25 2023

Hi,

I have defined a couple of rest datasources in apex using POST JSON Odata

In the POST body i've added a couple of Parameters:

{
"RequisitionNo": "XXXXXXX",
"Contract": "XXX",
"Description": "#Description#",
"WantedReceiptDate": "#RecieptDate#",
"RequestType": "RequestForQuotation",
"OriginalQty": #Qty#,
"PurchaseQty": 5,
"PartNo": "#Partno#",
"UsePriceInclTax": true,
"ExchangeItem": "ItemNotExchanged",
"SupplierSplit": "Split",
"CreateFaObj": false,
"FaObjPerUnit": false
}

I've created a process using type invoke API where my 4 variable parameters appears:
Partno
Description
Qty
RecieptDate

How do I utilize these parameters in an interactive grid operation where I want to select for example three rows and have them processed with a button “Create Requsition”.
I imagine I need to have a dynamic action with a for loop that updates "item" on each parameter and then somehow have that dynamic action invoke the process to start processing current values in item for the API call and do that for x amount selected rows.

Any other good idéas on how to make this work? I'm fairly new to Apex as you can imagine :)

Regards

Øyvind

This post has been answered by Carsten Czarski-Oracle on Sep 25 2023
Jump to Answer
Comments
Post Details
Added on Sep 25 2023
8 comments
709 views