Are you receiving SNAP/EBT or WIC benefits? The Expensify.org/SNAP-WIC-VAX campaign is live and accepting new members. Learn more about receiving $50 for submitting a SNAP/WIC receipt and $50 for getting your COVID-19 vaccine here and join today!
Integrations API returns incorrect JSON in some cases

Hi,
We have the following setup to fetch reports:
RequestJobDescription parameter:
{ "type": "file", "credentials": { "partnerUserID": "", "partnerUserSecret": "" }, "onReceive": { "immediateResponse": [ "returnRandomFileName" ] }, "inputSettings": { "type": "combinedReportData", "reportState": "OPEN,APPROVED,REIMBURSED", "filters": { "startDate": "2020-01-01", "endDate": "2050-01-01" } }, "outputSettings": { "fileExtension": "json", "fileBasename": "export" } }
Template parameter:
<#if addHeader> [<#lt> </#if> <#list reports as report> {<#lt> "accountID": "${report.accountID}",<#lt> "accountEmail": "${report.accountEmail}",<#lt> "status": "${report.status}",<#lt> "submitDate": "${report.submitted}",<#lt> "createdDate": "${report.created}",<#lt> "currency": "${report.currency}",<#lt> }<#sep>,</#sep><#lt> </#list> <#if addFooter> ] </#if>
It works fine with some integrations but for some of the integrations response that is constructed from Expensify API just missing commas between some of the entities in JSON array. For example, we have a JSON response of 65k lines and there is missing comma on the line 1203, just in random place.
Are there any fixes about this problem?
Answers
-
We allwoo woo allapple.c#ERRapple.c#ERROR! apple.c#ERROR! oapple.c#ERROR! omm omORapple.c#ERROR! oapple.c#ERROR! ommapple.c#ERROR! omapple.c#ERROR! om! omallapple.c#ERRapple.c#ERROR! apple.c#ERROR! oapple.c#ERROR! omm omORapple.c#ERROR! oapple.c#ERROR! ommapple.c#ERROR! omapple.c#ERROR! om! om