I created a new source with Webservice Connector, with two HTTP operations. Its says Account scanned = 0 and Status = Success in the Aggregation Activity log. Please advise.
Hello Mathew,
Welcome to the community.
Double check your response mapping please:
The schema attribute name mentioned on the left hand side must be same as attributes defined in your Source Account Schema (Source → Import Data → Account Schema). If it doesn’t match response mapping doesn’t work and you won’t see any accounts aggregated.
Also make sure your Attribute Path on right hand side matches with names in your JSON response being returned by the API. In Response Information populate the appropriate root element as well.
You can refer to an example here - Aggregation
Hope this helps.
Thank you so much Sharvari . I checked all and still its not pulling records. Below snapshots
JSON Payload:
{
“UserData”: {
“User”: [
{
“UserName”: “1XXXX05”,
“Company”: “AL”,
“Role”: “View Only”,
“Email”: “[email protected]”,
“Status”: “Active”,
“Airports”: {
“Airport”: [
“T1”
]
}
},
{
“UserName”: “2XXXXX”,
“Company”: “AS”,
“Role”: “View Only”,
“Email”: “[email protected]”,
“Status”: “Active”,
“Airports”: {
“Airport”: [
“T2”
]
}
}
]
}
}
RootPath: $UserData.
Account Aggregation Mapping
Account Schema:
I’m not sure if you need to provide period on the rootpath $UserData, i wonder the API will add while parsing
yes. I found the issue. The Root Path should be $.UserData.User[*]
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
