Expensify.org/hunger SNAP campaign status


The number of families signing up for reimbursement has vastly outnumbered the limited funds available. Though we’re unable to provide a specific timeline on when your report will be reimbursed, we’re doing our best to drive donations and keep reimbursements moving forward. Rest assured, we’ll review every report that has been submitted per our instructions.


We're no longer accepting new participants as our focus is on reimbursing existing claims. Additionally, as of July 1, 2020, we will no longer accept new report submissions from existing policy members. Thanks for your understanding!


If you know anyone who can donate to this campaign please direct them to Expensify.org/donate.

We're currently experiencing issues with our American Express and Capital One connections. Please visit our status page for more details and to subscribe to updates.

Issue on Expense Reports using API from MS Dynamics NAV 2018

rajatmongarajatmonga Expensify Customer Posts: 3
edited April 2019 in Integrations and API

Hi Team,

Hope you doing good…!!

We are facing an issue regarding downloading Expense Reports using API from MS Dynamics NAV 2018, as the file is not getting generated on the API request.

Please check on the same and assist, if we are missing something.


Also, Please refer to below for your reference for issue analysis:

  1. a. Attached codeunit Expensify_Integration_Function.txt – Function name GetExpReporstListCURL(), that is being used for downloading expense reports.
  2. API Request Details

"C:\Expensify\curl-7.54.0-win64-mingw\bin\curl.exe" -X POST http://integrations.expensify.com/Integration-Server/ExpensifyIntegrations -d 'requestJobDescription="{type:file,credentials:{partnerUserID:*******,partnerUserSecret:****************************************},onReceive:{ immediateResponse:[returnRandomFileName] },inputSettings:{type:combinedReportData,filters:{startDate:2016-01-01,endDate:2019-12-31}},outputSettings:{ fileExtension:csv, fileBasename:allExpReps },onFinish:[{ actionName:markAsExported, label:Expensify Export }]}' --data-urlencode '[email protected]:\Expensify\curl-7.54.0-win64-mingw\bin\expensify_template.ftl' -H Expect:


Regards,

Rajat Monga


Answers

  • Francois LaithierFrancois Laithier Expensify Team Posts: 22 Expensify Team
    edited April 2019

    Hi Rajat,


    When you executed the curl request, you should have received a response from the Expensify API. Can you please share it here? It should indicate if anything went wrong.


    One thing that looks incorrect with the request so far though is that the value of the requestJobDescription parameter should be valid JSON, so:

    'requestJobDescription="{type:file,credentials:{partnerUserID:xx,partnerUserSecret:yy} (etc.)
    

    should be:

    'requestJobDescription={"type":"file","credentials":{"partnerUserID":"xx","partnerUserSecret":"yy"} (etc.)
    


  • rajatmongarajatmonga Expensify Customer Posts: 3
    edited June 2019

    Hi @Francois,

    Hope you doing good…!!

    As per your update to the issue, I have tried updating the request as below, but still not getting results:

    API Request Details:

    "C:\Expensify\curl-7.54.0-win64-mingw\bin\curl.exe" -X POST http://integrations.expensify.com/Integration-Server/ExpensifyIntegrations -d requestJobDescription="{"type":"file","credentials":{"partnerUserID":"xx","partnerUserSecret":"yy"},"onReceive":{ "immediateResponse":"[returnRandomFileName]" },"inputSettings":{"type":"combinedReportData","filters":{"startDate":"2016-01-01","endDate":"2019-12-31"}},"outputSettings":{ "fileExtension":"csv", "fileBasename":"allExpReps" },"onFinish":"[{ "actionName":"markAsExported", "label":"Expensify Export" }]"}" --data-urlencode "[email protected]:\Expensify\curl-7.54.0-win64-mingw\bin\expensify_template.ftl" -H "Expect":


    Also, Please attached the response for your reference.


    Please check on the same and assist, if we are missing something.


    Regards,

    Rajat Monga

  • Francois LaithierFrancois Laithier Expensify Team Posts: 22 Expensify Team

    Hi Rajat,

    Looks like you have an issue with the format of the request and the double quotes, so curl cannot execute the request at all. You might be able to find help on how to format curl requests on Windows here, here, or here.

    Cheers

  • rajatmongarajatmonga Expensify Customer Posts: 3

    Hi Team,

    As per update from Francois, the issue is still not resolved.

    Please check on the same and assist, if we are missing something.

    Also, Please refer to below for your reference for issue analysis:

    1.  Attached codeunit Expensify_Integration_Function.txt – Function name GetExpReporstListCURL(), that is being used for downloading expense reports.

        2. API Request:

    "C:\Expensify\curl-7.54.0-win64-mingw\bin\curl.exe" -X POST https://integrations.expensify.com -d requestJobDescription={"type":"file","credentials":{"partnerUserID":"aa_rajat_inecta_com","partnerUserSecret":"cec4183e990b1e4efb2d6899f59287c407f55a26"},"onReceive":{"immediateResponse":["returnRandomFileName"]},"inputSettings":{"type":"combinedReportData","filters":{"startDate":"2016-01-01","endDate":"2019-12-31"}},"outputSettings":{"fileExtension":"csv", "fileBasename":"allExpReps"},"onFinish":[{"actionName":"markAsExported", "label":"Expensify Export"}]} --data-urlencode "[email protected]:\Expensify\curl-7.54.0-win64-mingw\bin\expensify_template.ftl" -H Expect:


    3. CURL Response.jpg


    Regards,

    Rajat Monga


Sign In or Register to comment.