I am trying to read some attributes in the SSFF connector and I am not able to read the “secondLastName” even though I should be able to read it without any problem since the context URL points to the table where this attribute is located.
This is te context URL “/odata/v2/EmpJob?$format=json&$top=1000&$skip=0&$expand=employmentNav/personNav/personalInfoNav”
And i can read “personIdExternal” and “dateOfBirth” like this “employmentNav.personNav.personIdExternal” and “employmentNav.personNav.dateOfBirth”
But i cant with “secondLastName” like this “employmentNav.personNav.personalInfoNav.secondLastName”

In the image you can see that the route is the correct one “personalInfoNav.secondLastName” but it still doesn’t read it.
@Juanisola did you try with following? It should work
employmentNav/personNav/personalInfoNav/secondLastName
Regards,
Shekhar Das
When I add the path to the context url it gives me the following error
“sailpoint.connector.ConnectorException: Url: https://api8preview.sapsf.com//odata/v2/EmpJob?$format=json&$top=1000&$skip=0&$expand=employmentNav/personNav/personalInfoNav/secondLastName, Message: 400 : Bad Request, HTTP Error Code: 400”
And when I add the path to the attribute mapping I still don’t read it
Try below:
https://api8preview.sapsf.com/odata/v2/EmpJob?$select=employmentNav/personNav/personalInfoNav/secondLastName&$format=json&$top=1000&$skip=0
Regards,
Shekhar Das
By the way you have double // before odata/v2 in your context URL JFYI.
Are you trying to map this information in the Response Mapping section to assign it to an account schema attribute? If so, you can try this:
employmentNav.personNav.personalInfoNav.results[*].secondLastName
You can also take the response body and put it into JSONPath to test out the syntax needed to get the attributes you are looking for.
Apparently adding the results[] the mapping is working, thank you very much to both.
I don’t know if it has anything to do with it but all the attributes that were failing, I had to navigate through more than 3 tables. those that went through less than 2 tables were mapped correctly without the results[
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.