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

[former_member501247]

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>
<Department>LM10</Department>

</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?

[Sriprasadsbhat]

Hello Vignesh,

Please refer below link for more details

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

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

[former_member501247]

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.