I tried searching through the forums for a similar issue but couldn't find anything relevant.
I have a system that returns a list of account names in an array. I want to pass this into a second call to get detailed information about the accounts. Sadly, there is no endpoint where I can get the full list of information in one request.
An example response from the API is as follows:
Call1
{
"data": {
"values": [
"foo",
"bar",
"baz"
]
}
}
Call2
{
"data": {
"id": "1234",
"name": "foo",
"created": "2024-02-01T00:00:00.00000000Z",
"disabled": false
}
}
I've tried processing this with the following JSON configuration to no avail:
{
"accountParams": {
"connection": "auth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"listField": "data.values",
"keyField": "accountID",
"http": {
"url": "https://the.endpoint.com/users",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {}
},
"colsToPropsMap": { "accountID": "~#~char", "name": "~#~char" }
},
"call2": {
"callOrder": 1,
"keyField": "accountID",
"nextApiKeyField": "accountID",
"http": {
"url": "https://the.endpoint.com/users/${accountID}",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {}
},
"inputParams": {
"dependentCall": true
},
"colsToPropsMap": {
"accountID": "data.id~#~char",
"name": "data.name~#~char",
"createdon": "data.created~#~date",
"status": "data.disabled~#~bool",
"displayName": "data.name~#~char"
}
}
}
}
}
Running this returns log entries like the following for each of the items in Call1:
INFO: Account Name is null, record not saved.
Exception in RestUtil.getAt : groovy.lang.MissingPropertyException: No such property: for class: java.lang.String
Possible solutions: class, bytes, empty
I have showLogs set in the connection and I do see a successful response with the data from Call1 in the logs. I am guessing that there's some special syntax needed for colsToPropsMap when the field is just a string, but I can't find a relevant example in any of the documentation.
