Access Import Mapping Issue

[ashutosh]

Hi All,

For the below given sample response how we will be able to map the property "Location_Usage_ID" in import mapping ?

Endpoint :Workday

Connection : WorkSoap

At present I tried with below given sample mapping but it did not worked.

1 . "CUSTOMPROPERTY2": "Location_Data.Location_Usage_Reference.ID@type='Location_Usage_ID'"

2.  "CUSTOMPROPERTY2": "Location_Data.Location_Usage_Reference.Location_Usage_ID"

3.  "CUSTOMPROPERTY2": "Location_Data.Location_Usage_Reference.@Location_Usage_ID"

Sample Response Data:

wd:Response_Data>

                <wd:Location>

                    <wd:Location_Data>

                        <wd:Location_ID>88072</wd:Location_ID>

                        <wd:Location_Name>LS MOSCOW GOODZONE</wd:Location_Name>

                        <wd:Location_Usage_Reference>

                            <wd:ID wd:type="WID">abcdkjhkjdhakshdkasdjh</wd:ID>

                            <wd:ID wd:type="Location_Usage_ID">BUSINESS SITE</wd:ID>

                        </wd:Location_Usage_Reference>

                        <wd:Location_Type_Reference>

                            <wd:ID wd:type="WID">kjhakshkdjhakdjhaskdj</wd:ID>

                            <wd:ID wd:type="Location_Type_ID">Retail Store</wd:ID>

                        </wd:Location_Type_Reference>

........................

[Miguel]

Hello!  Thank you for your question!   We are investigating an answer. Someone will get back to you soon.

 Miguel

[sahajranajee]

Hello,

What is the ResponsePath in your JSON?
You would have to use mapping similar to:
ID(@wd:type=='Location_Usage_ID')