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!

Oracle APEX applicaiton: REST Data Source >(POST)Request Body Template Issue

Devashish SaunFeb 7 2025 — edited Feb 7 2025

I am setting up request payload from PLSQL.

My Rest Data Source> Request Body Template:

{

“PurchaseOrderNumber": "#PurchaseOrderNumber#"

}

PLSQL Code:

apex_exec.add_parameter(l_params, 'PurchaseOrderNumber', current_record.PURCHASE_ORDER);

Current Behavoiur

When c_urrent_record.PURCHASE_ORDER_ has some value it works fine, but when it is blank, it fails

{

“PurchaseOrder": ""

}

My Payload expects
{

“PurchaseOrder": null

}

This post has been answered by Yassine Wahbi-Oracle on Feb 7 2025
Jump to Answer
Comments
Post Details
Added on Feb 7 2025
1 comment
515 views