Need help in SAP SuccessFactor ImportUser Mapping

[Jaya]

Hi All,

I need help in mapping nested & multivalued attribute in ImportUserJson's colsToPropsMap

This is the query which I have taken from SAP SuccessFactor Connector Guide - https://saviynt.freshdesk.com/support/solutions/articles/43000478793-sap-successfactors-connector-gu...

So when I use results[0] I am able to fetch results at the first place of solution array, but in our use case latest value is coming at the last place of result array and with this query 'empInfo/jobInfoNav/startDate+asc' we are not able to sort data with startdate(when data is updated), so my question is how to fetch value at last place of array.

NOTE: I have tried results[-1], results[-1:],results[length-1] but it doesn't work.

Please help.

Thanks,

Jaya

@Nikitaj @rushikeshvartak 

[SB]

Let me check this and will update.

[Saathvik]

Can you try this results[length()-1] or  results[size()-1]

[rushikeshvartak]

"companyname": "empInfo.jobInfoNav.results[empInfo.jobInfoNav.results.size()-1].companyNav.name~#~char"

[Jaya]

Hi Sk/rushikesh,

I have tried all these 3 methods but I am getting value as Null.

I have attached the logs for your reference.

Thanks,

Jaya

@Saathvik 

[Saathvik]

Try below 

empInfo.jobInfoNav.results[Integer.valueOf(String.valueOf(empInfo.jobInfoNav.results.size()-1))]

[Jaya]

Still it's Null

PFA error message

[SB]

Can you share a sample of the response text from Postman and the intended value we need to fetch.

[rushikeshvartak]

"companyname": "empInfo.jobInfoNav.results[empInfo.jobInfoNav.length -1].companyNav.name~#~char"