Retrieving non-billable expenses with the API

MedW

Greetings, We are using the API to integrate expense reports into our internal accounting tool. I can indeed retrieve expenses, but only those which have been checked as "Billable" I'm using the following inputSettings in the API call:

                "inputSettings":{
                  "type":"combinedReportData",
                  "reportState":"OPEN,SUBMITTED,APPROVED,REIMBURSED,ARCHIVED",
                  "filters":{
                    "policyIDList":"'.self::POLICY_ID_LIST.'",
                    "startDate":"'.$startDate.'",
                    "endDate":"'.$endDate.'"
                    }
                },

Does anyone know how I can retrieve expenses that are "non-billable"? I'm failing to see how this can be done looking at the API documentation.

Thanks for any insight.

Nicole Trepanier

@MedW Can you send us the full API call and be sure to remove or block out any credential information? When you use the exporter API, you should also receive a file containing all of the exported expenses. Can you confirm that this file is missing the non-billable expenses?

MedW

Thnaks Nicole,

Actually I jumped the gun a bit posing about this... I realize now that all the expenses i was receiving were both billable and non-billable. All I had to do was add the 'billable' field in the Report template at the expense level. After I did that I was able to filter them out after receiving the data from the API.

[Deleted User]

Great to hear that you got that sorted out!  Please let us know if you have questions moving forward!