06-22-2021 07:21 AM
I’ve come across an issue where the REST post works using a JSON generator, but when we receive the JSON from the pipeline and post it, the call fails. The JSON payload is exactly the same between the JSON generator and what we receive, yet we cannot get the POST call to fire successfully.
JSON Payloads is as follows:
[
{
“kind”: “doubleclicksearch#conversionList”,
“conversion” : [{
“clickId” : “XXXXXXXXXXXXXXXXXXMYaAunkEALw_wcB”,
“conversionId” : “XXXXXXXXXXXzhXE5AAM”,
“conversionTimestamp” : “1623361621000”,
“segmentationType” : “FLOODLIGHT”,
“segmentationName” : “SFDC_Wins”,
“type”: “ACTION”
},
{
“clickId” : “XXXXXXXXXXXXd69532af3081b22f4”,
“conversionId” : “XXXXXXXXXXXXXzhW2pAAE”,
“conversionTimestamp” : “1623352858000”,
“segmentationType” : “FLOODLIGHT”,
“segmentationName” : “SFDC_Wins”,
“type”: “ACTION”
}
]
}
]
06-22-2021 07:31 AM
Hi @shawnharv,
Try and wrap the payload into one object, and pass that object into the Entity field in the REST Post snap.
Something like this:
[
{
“payload”: {
“kind”: “doubleclicksearch#conversionList”,
“conversion”: [
{
“clickId”: “XXXXXXXXXXXXXXXXXXMYaAunkEALw_wcB”,
“conversionId”: “XXXXXXXXXXXzhXE5AAM”,
“conversionTimestamp”: “1623361621000”,
“segmentationType”: “FLOODLIGHT”,
“segmentationName”: “SFDC_Wins”,
“type”: “ACTION”
},
{
“clickId”: “XXXXXXXXXXXXd69532af3081b22f4”,
“conversionId”: “XXXXXXXXXXXXXzhW2pAAE”,
“conversionTimestamp”: “1623352858000”,
“segmentationType”: “FLOODLIGHT”,
“segmentationName”: “SFDC_Wins”,
“type”: “ACTION”
}
]
}
}
]
Don’t forget the Content-Type Header:
06-22-2021 08:19 AM
Thanks [bojanvelevski] for the quick response.
I tried wrapping this in the payload object like you suggested, but still no success. The doubleclick search API responds with “The request was not valid. Details: [Empty batch encountered]”.
Its very strange how the payload works when its coming from a JSON generator snap, but the same JSON payload coming from a file fails. The two are literally the same haha.
Thanks,
Shawn
06-22-2021 08:31 AM
Please review and post a screenshot of the Pipeline Execution Statistics of each version of the pipeline – the one with the JSON Generator and the one without. This will give us more information about exactly how many input documents are being received by the REST Post.
06-22-2021 08:48 AM
I think we found a solution to this. All ill say is camelCase lol.
Thank you all for your quick responses and suggestions.
Regards,
Shawn