Question Re: Variable Resource path based on incoming data while using SAP Open Connectors in Technology Q&A

Variable Resource path based on incoming data while using SAP Open Connectors

former_member501247 — Mon, 10 May 2021 19:56:45 GMT

Hello Experts,

I have established connection to Dayforce CRM systems via SAP Open Connectors. In Integration Flow, I have to pass the Resource value {id} in the below path based on the value received in the XML field from source. I am finding it difficult to pass this value to the Resource Path. Can you please suggest a way to pass the value to the variable {id} in the URL path.

Sample Source XML:

<?xml version='1.0' encoding='UTF-8'?>

</EmpDetails>

I need to pass LM10 value to {id} in the Resource path. I have tried to pass the value by setting XPATH type condition and passing them to header (${header.department}) and exchange property(${property.department}), but unfortunately the value is not being passed to the URL.

It works if I pass a constant value under Query parameters for Resource like id=LM10, but I need to pass variable value based on the payload data.

Can you please help me on this issue with a solution/blog which I can refer to?

Re: Variable Resource path based on incoming data while using SAP Open Connectors

Sriprasadsbhat — Tue, 11 May 2021 03:25:32 GMT

Hello Vignesh,

Please refer below link for more details

https://help.sap.com/viewer/368c481cd6954bdfa5d0435479fd4eaf/Cloud/en-US/1a27cee87cd14ef69ca56fb50b1e3983.html

Define the value of a variable you want to modify. For example, you have defined a variable /name/{varname1}{varname2} in the resource field. Now use the Query Parameters for Resource field to define the value for {varname1}{varname2} variables. Use commas to separate more than variable such as varname1=hello world, varname2= hello SAP.

As usage of property and headers not supported you can raise a reuqest to SAP get this feature.As an alternative you can use HTTP adapter to connect to your Open Connectors instance which supports dynamic variables.

Regards,

Sriprasad Shivaram Bhat

Re: Variable Resource path based on incoming data while using SAP Open Connectors

former_member501247 — Tue, 11 May 2021 05:34:49 GMT

Hello Sriprasad,

Thanks for the valuable suggestion. Can we enable this feature of passing Dynamic header/property variables to Open connector Resource path by raising an request to SAP ? If its possible to enable this feature for our account, then I would proceed with this request to SAP.

Re: Variable Resource path based on incoming data while using SAP Open Connectors

Sriprasadsbhat — Tue, 11 May 2021 05:44:41 GMT

Hello Vignesh,

I dont thinkit will be available immediatelyif you raise a ticket as it should go through developement lifecycle for feature enablement.

I would suggest ( personal suggestion ) go with HTTP adapter as interim solution.

Please raise improve request using below link ( customer influence program ).

https://blogs.sap.com/2020/05/29/central-sap-cloud-platform-feedback-requirements-channel-for-customers-and-partner-now-available/

Regards,

Sriprasad Shivaram Bhat