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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on Feb 7 2025
1 comment
123 views