P6 Spread Service

Hi All,

I have a couple of questions regarding the following products:

Primavera P6 Professional 21.12.7.44384

Apex ORDS 23.1.0

 

We are in the process of setting up the link between apex and P6 through the REST API and have had good success up until trying to implement the spread service where I keep getting the following from Apex: “{"message":"Invalid request."}.

 

This is driven by the following code:

apex_web_service.g_request_headers.delete;

apex_web_service.g_request_headers(1).name := 'content-type';

apex_web_service.g_request_headers(1).value := 'application/json; charset=utf-8';

 

 l_clob:= APEX_WEB_SERVICE.MAKE_REST_REQUEST (