ORDS Header and Bind Variables

I have struggled with this thing too;

For me the information on this page was of real help:

Cloud Nueva Accessing CGI Information from ORDS Handlers - Cloud Nueva, INC.

Bind variables are accessed via :BIND_VARIABLENAME

If you are looking for preset bind variables check:

https://www.smartdogservices.com/ords-use-case-integrating-salesforce-com-customers-to-ebs/

If you are working with OAuth :current_user comes in very handy.

 

ORDS provides the following help in parsing JSON request bodies as well as other useful bind variables for accessing the http header etc. :

 

• Pagination control – :page_size, :page_offset, :row_offset, :row_count
• For authenticated requests – :current_user
• Parameters from the URI template become bind variables
• Request entity – :content_type, :body
• Request entity – A simple JSON object is parsed and creates a bind variable for each Property. A x-www-form-urlencoded body is parsed and creates a bind variable for each parameter.
• Any HTTP request header can be mapped to a bind variable
• OWA environment OWA_UTIL.GET_CGI_ENV
• Special pseudo headers from Listener

          o    X-APEX-BASE – the base URL of the request

          o    X-APEX-PATH – the path of the request relative to the base

          o    X-APEX-CHARSET – the character set of the request body

          o    X-APEX-METHOD – the HTTP method used to make the request

          o    X-APEX-PREFERRED-CONTENT-TYPE – from parsing the Accept HTTP request, identifies the MOST preferred content type that the client would like to receive