Simple C# sample for extraction of all reconciliation data between dates

Hillebrt

I would love to see a very simple working example of how to use the API within a C# application. What I find is apparently too advanced for me :-). I am not able to translate and get anything working. I need something that sets up the call, makes the call, and iterates the result. Any help would be very much appreciated. Thank you!

Hillebrt

Cry for help....I am really stuck on this and need to get it working. The Concierge tells me that no one out there is using their API with C# and that the API is self-serve only. I accept that. But, maybe someone can look at where I'm at and see what might be wrong with my syntax. I'm getting an "Unauthorized" error #401.

I'm attaching a file with a snippet that represents my POST.

CodeSample.docx

Zany Renney

Hi there @Hillebrt - all our API resources on the community can be found here: https://community.expensify.com/categories/integrations-API

I've taken a look at your query and this isn't something I am familiar with so I'd suggest checking out those help docs linked above or asking someone technical in your organisation.

Thanks for writing in - I hope we can crowdsource the answer for you!

Hillebrt

Thank you very much Zany. I will review what you are providing. I went in search of error code #401 as it seemed generic and not specific to anything particular I'm doing with C#. I found this. It is similar to what I am experiencing and am now thinking that I have hit a locked door that only Epensify holds the key to?

Importing / updating employees via CSV — Expensify Community

Zany Renney

Is your issue that you are trying to import or update employees?

Hillebrt

No. I am trying export expenses. But, the error code #401 is the same - "Unauthorized".

Hillebrt

The error code tells me that I have my syntax correct and I've made my way to the door and am knocking on the door, but the door won't open. It isn't telling me I have the wrong credentials. From the other post, it seems there is some configuration on your end that must happen in order for the door to be opened.

Zany Renney

Hmm, no the API is self-serve so typically there is no input required from Expensify's side. Please can you refer to this post and the accompanying links to see if this helps you obtain the details required for the Report export here.

Thank you!

Hillebrt

I am slow in getting around to following up. I'm still trying to get this to work. Can someone please help? I'm attaching my C# code. I am getting the following error message:

responseString = "{\"responseMessage\":\"Argument 'inputSettings' is missing or malformed\",\"responseCode\":410}"

I very much would like to get this working. I want all expenses from all reports. I've played around with inputSettings and its associated filter in all kinds of ways. I'm missing something basic and fundamental.

Thank you. Thank you. Anyone out there who works in C#? I'm trying to pull Expensify data into excel through VSTO and combining it with financial data from Tiller.

ExpensifyAPI Example.txt