Are you receiving SNAP/EBT benefits? The Expensify.org/SNAP-VAX campaign is live and accepting new members. Learn more about receiving $50 for submitting a SNAP receipt and $50 for getting your COVID-19 vaccine here and join today!

Integrations API returns incorrect JSON in some cases

Oveo_integrations
Oveo_integrations Expensify Customer Posts: 1

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