Integrations API returns incorrect JSON in some cases

Oveo_integrations

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?

Valrod36

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