Back to Collection Items
Use ChilkatAx-9.5.0-win32.pkg
Procedure Test
Handle hoHttp
Boolean iSuccess
Variant vQueryParams
Handle hoQueryParams
Variant vResp
Handle hoResp
Variant vSbResponseBody
Handle hoSbResponseBody
Handle hoJResp
Integer iRespStatusCode
String sAccount_name
String sAccountid
String sAccounting_systemid
String sAmount
String sCode
Integer iAttachmentid
Integer iId
String sV_Jwt
String sMedia_type
String sBackground_jobid
String sBank_name
String sCategory
Integer iCategoryid
String sCreated_at
Integer iCategoryId
Boolean iIs_cogs
Boolean iIs_editable
Integer iParentid
String sUpdated_at
Integer iVis_state
Integer iCategoryid
Integer iClientid
Boolean iCompounded_tax
String sDate
String sExpense_profile
Integer iExpenseid
Integer iExt_invoiceid
Integer iExt_systemid
Boolean iFrom_bulk_import
Boolean iHas_receipt
Integer iId
Boolean iInclude_receipt
String sInvoiceid
Boolean iIs_cogs
Boolean iIsduplicate
String sMarkup_percent
String sNotes
String sProfileid
String sProject
Integer iProjectid
Integer iStaffid
Integer iStatus
String sTaxAmount1Amount
String sTaxAmount1Code
String sTaxAmount2
String sTaxName1
String sTaxName2
String sTaxPercent1
String sTaxPercent2
String sTransactionid
String sUpdated
String sVendor
Integer iVis_state
String sAttachment
String sTaxAmount1
Integer iPage
Integer iPages
Integer iPer_page
Integer iTotal
Integer i
Integer iCount_i
String sTemp1
Boolean bTemp1
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Get Create (RefClass(cComChilkatHttp)) To hoHttp
If (Not(IsComObjectCreated(hoHttp))) Begin
Send CreateComObject of hoHttp
End
Get Create (RefClass(cComChilkatJsonObject)) To hoQueryParams
If (Not(IsComObjectCreated(hoQueryParams))) Begin
Send CreateComObject of hoQueryParams
End
Get ComUpdateString Of hoQueryParams "include[]" "attachment" To iSuccess
Get ComUpdateString Of hoQueryParams "include[]" "category" To iSuccess
Get ComUpdateString Of hoQueryParams "include[]" "expense_profile" To iSuccess
Get ComUpdateString Of hoQueryParams "include[]" "project" To iSuccess
Get ComUpdateString Of hoQueryParams "include[]" "account" To iSuccess
// Adds the "Authorization: Bearer <access_token>" header.
Set ComAuthToken Of hoHttp To "<access_token>"
Send ComSetRequestHeader To hoHttp "Content-Type" "application/json"
Get pvComObject of hoQueryParams to vQueryParams
Get ComQuickRequestParams Of hoHttp "GET" "https://api.freshbooks.com/accounting/account/{{accountId}}/expenses/expenses" vQueryParams To vResp
If (IsComObject(vResp)) Begin
Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
Set pvComObject Of hoResp To vResp
End
Get ComLastMethodSuccess Of hoHttp To bTemp1
If (bTemp1 = False) Begin
Get ComLastErrorText Of hoHttp To sTemp1
Showln sTemp1
Procedure_Return
End
Get Create (RefClass(cComChilkatStringBuilder)) To hoSbResponseBody
If (Not(IsComObjectCreated(hoSbResponseBody))) Begin
Send CreateComObject of hoSbResponseBody
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComGetBodySb Of hoResp vSbResponseBody To iSuccess
Get Create (RefClass(cComChilkatJsonObject)) To hoJResp
If (Not(IsComObjectCreated(hoJResp))) Begin
Send CreateComObject of hoJResp
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComLoadSb Of hoJResp vSbResponseBody To iSuccess
Set ComEmitCompact Of hoJResp To False
Showln "Response Body:"
Get ComEmit Of hoJResp To sTemp1
Showln sTemp1
Get ComStatusCode Of hoResp To iRespStatusCode
Showln "Response Status Code = " iRespStatusCode
If (iRespStatusCode >= 400) Begin
Showln "Response Header:"
Get ComHeader Of hoResp To sTemp1
Showln sTemp1
Showln "Failed."
Send Destroy of hoResp
Procedure_Return
End
Send Destroy of hoResp
// Sample JSON response:
// (Sample code for parsing the JSON response is shown below)
// {
// "response": {
// "result": {
// "expenses": [
// {
// "account_name": "",
// "accountid": null,
// "accounting_systemid": "wkMd2g",
// "amount": {
// "amount": "79.73",
// "code": "USD"
// },
// "attachment": {
// "attachmentid": 8668,
// "id": 8668,
// "jwt": "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhY2NvdW50Ijo0MjM2NDEwLCJvcmlnaW5hbF9maWxlbmFtZSI6IlNjcmVlbiBTaG90IDIwMTktMDQtMjQgYXQgOS4zOS4xOSBBTS5wbmciLCJidWNrZXQiOiJ1cGxvYWRzIiwiZmlsZW5hbWUiOiJ1cGxvYWQtMGU2ZDMwOWQ1ZTI5MzA3NmNhMGIyNDdkODFlOGJlNWE4NDZlZWE0YSIsImxlbmd0aCI6MTkxNDcyLCJrZXkiOiInZG9jcy0nLTQyMzY0MTAvdXBsb2FkLTBlNmQzMDlkNWUyOTMwNzZjYTBiMjQ3ZDgxZThiZTVhODQ2ZWVhNGEifQ.SOoW3_nTUrxjYO76g1UXHPIrO_aLbTpXCHEa-ZcnejA",
// "media_type": "image/png"
// },
// "background_jobid": null,
// "bank_name": "",
// "category": {
// "category": "Gas",
// "categoryid": 2003174,
// "created_at": "2019-04-18 09:14:52",
// "id": 2003174,
// "is_cogs": false,
// "is_editable": false,
// "parentid": 2003170,
// "updated_at": "2019-04-18 09:14:52",
// "vis_state": 0
// },
// "categoryid": 2003174,
// "clientid": 0,
// "compounded_tax": false,
// "date": "2019-04-24",
// "expense_profile": null,
// "expenseid": 1825568,
// "ext_invoiceid": 0,
// "ext_systemid": 0,
// "from_bulk_import": false,
// "has_receipt": true,
// "id": 1825568,
// "include_receipt": false,
// "invoiceid": null,
// "is_cogs": false,
// "isduplicate": true,
// "markup_percent": "0",
// "notes": "Purchased Gasoline for deliveries",
// "profileid": null,
// "project": null,
// "projectid": 0,
// "staffid": 1,
// "status": 0,
// "taxAmount1": {
// "amount": "9.17",
// "code": "USD"
// },
// "taxAmount2": null,
// "taxName1": "other tax",
// "taxName2": null,
// "taxPercent1": "13",
// "taxPercent2": null,
// "transactionid": null,
// "updated": "2019-04-24 11:33:35",
// "vendor": "Shell Gas Station",
// "vis_state": 0
// },
// {
// "account_name": "",
// "accountid": null,
// "accounting_systemid": "wkMd2g",
// "amount": {
// "amount": "79.73",
// "code": "USD"
// },
// "attachment": {
// "attachmentid": 8670,
// "id": 8670,
// "jwt": "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhY2NvdW50Ijo0MjM2NDEwLCJvcmlnaW5hbF9maWxlbmFtZSI6IlNjcmVlbiBTaG90IDIwMTktMDQtMjQgYXQgOS4zOS4xOSBBTS5wbmciLCJidWNrZXQiOiJ1cGxvYWRzIiwiZmlsZW5hbWUiOiJ1cGxvYWQtMGU2ZDMwOWQ1ZTI5MzA3NmNhMGIyNDdkODFlOGJlNWE4NDZlZWE0YSIsImxlbmd0aCI6MTkxNDcyLCJrZXkiOiInZG9jcy0nLTQyMzY0MTAvdXBsb2FkLTBlNmQzMDlkNWUyOTMwNzZjYTBiMjQ3ZDgxZThiZTVhODQ2ZWVhNGEifQ.SOoW3_nTUrxjYO76g1UXHPIrO_aLbTpXCHEa-ZcnejA",
// "media_type": "image/png"
// },
// "background_jobid": null,
// "bank_name": "",
// "category": {
// "category": "Gas",
// "categoryid": 2003174,
// "created_at": "2019-04-18 09:14:52",
// "id": 2003174,
// "is_cogs": false,
// "is_editable": false,
// "parentid": 2003170,
// "updated_at": "2019-04-18 09:14:52",
// "vis_state": 0
// },
// "categoryid": 2003174,
// "clientid": 0,
// "compounded_tax": false,
// "date": "2019-04-24",
// "expense_profile": null,
// "expenseid": 1825574,
// "ext_invoiceid": 0,
// "ext_systemid": 0,
// "from_bulk_import": false,
// "has_receipt": true,
// "id": 1825574,
// "include_receipt": false,
// "invoiceid": null,
// "is_cogs": false,
// "isduplicate": true,
// "markup_percent": "0",
// "notes": "Purchased Gasoline for deliveries",
// "profileid": null,
// "project": null,
// "projectid": 0,
// "staffid": 1,
// "status": 0,
// "taxAmount1": {
// "amount": "9.17",
// "code": "USD"
// },
// "taxAmount2": null,
// "taxName1": "other tax",
// "taxName2": null,
// "taxPercent1": "13",
// "taxPercent2": null,
// "transactionid": null,
// "updated": "2019-04-24 11:38:00",
// "vendor": "Shell Gas Station",
// "vis_state": 2
// },
// {
// "account_name": "",
// "accountid": null,
// "accounting_systemid": "wkMd2g",
// "amount": {
// "amount": "79.73",
// "code": "USD"
// },
// "attachment": {
// "attachmentid": 12138,
// "id": 12138,
// "jwt": "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhY2NvdW50Ijo0MjM2NDEwLCJvcmlnaW5hbF9maWxlbmFtZSI6IlNjcmVlbiBTaG90IDIwMTktMDQtMjQgYXQgOS4zOS4xOSBBTS5wbmciLCJidWNrZXQiOiJ1cGxvYWRzIiwiZmlsZW5hbWUiOiJ1cGxvYWQtMGU2ZDMwOWQ1ZTI5MzA3NmNhMGIyNDdkODFlOGJlNWE4NDZlZWE0YSIsImxlbmd0aCI6MTkxNDcyLCJrZXkiOiInZG9jcy0nLTQyMzY0MTAvdXBsb2FkLTBlNmQzMDlkNWUyOTMwNzZjYTBiMjQ3ZDgxZThiZTVhODQ2ZWVhNGEifQ.SOoW3_nTUrxjYO76g1UXHPIrO_aLbTpXCHEa-ZcnejA",
// "media_type": "image/png"
// },
// "background_jobid": null,
// "bank_name": "",
// "category": {
// "category": "Gas",
// "categoryid": 2003174,
// "created_at": "2019-04-18 09:14:52",
// "id": 2003174,
// "is_cogs": false,
// "is_editable": false,
// "parentid": 2003170,
// "updated_at": "2019-04-18 09:14:52",
// "vis_state": 0
// },
// "categoryid": 2003174,
// "clientid": 0,
// "compounded_tax": false,
// "date": "2019-04-24",
// "expense_profile": null,
// "expenseid": 2721846,
// "ext_invoiceid": 0,
// "ext_systemid": 0,
// "from_bulk_import": false,
// "has_receipt": true,
// "id": 2721846,
// "include_receipt": false,
// "invoiceid": null,
// "is_cogs": false,
// "isduplicate": true,
// "markup_percent": "0",
// "notes": "Purchased Gasoline for deliveries",
// "profileid": null,
// "project": null,
// "projectid": 0,
// "staffid": 1,
// "status": 0,
// "taxAmount1": {
// "amount": "9.17",
// "code": "USD"
// },
// "taxAmount2": null,
// "taxName1": "other tax",
// "taxName2": null,
// "taxPercent1": "13",
// "taxPercent2": null,
// "transactionid": null,
// "updated": "2019-04-30 16:48:22",
// "vendor": "Shell Gas Station",
// "vis_state": 0
// },
// {
// "account_name": "",
// "accountid": null,
// "accounting_systemid": "wkMd2g",
// "amount": {
// "amount": "7000.99",
// "code": "USD"
// },
// "attachment": {
// "attachmentid": 6122,
// "id": 6122,
// "jwt": "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhY2NvdW50Ijo0MjM2NDEwLCJvcmlnaW5hbF9maWxlbmFtZSI6IlNjcmVlbiBTaG90IDIwMTktMDQtMTYgYXQgMTEuMzcuMjEgQU0ucG5nIiwiYnVja2V0IjoidXBsb2FkcyIsImZpbGVuYW1lIjoidXBsb2FkLTJjMDY0NDEwZDQwYjE1NTRkZTAyM2Q1MjNlNmJjOTA3NDMyYmIwMGMiLCJsZW5ndGgiOjE0NTk2MCwia2V5IjoiJ2RvY3MtJy00MjM2NDEwL3VwbG9hZC0yYzA2NDQxMGQ0MGIxNTU0ZGUwMjNkNTIzZTZiYzkwNzQzMmJiMDBjIn0.MogtZWv_c3mllnjMzX5DEP2J5PBsEa1ZfHwdXgywRoM",
// "media_type": "image/png"
// },
// "background_jobid": null,
// "bank_name": "",
// "category": {
// "category": "Computer Parts",
// "categoryid": 2005674,
// "created_at": "2019-04-18 09:40:57",
// "id": 2005674,
// "is_cogs": false,
// "is_editable": true,
// "parentid": 2003142,
// "updated_at": "2019-04-18 09:40:57",
// "vis_state": 0
// },
// "categoryid": 2005674,
// "clientid": 0,
// "compounded_tax": false,
// "date": "2019-04-18",
// "expense_profile": null,
// "expenseid": 1034972,
// "ext_invoiceid": 0,
// "ext_systemid": 0,
// "from_bulk_import": false,
// "has_receipt": true,
// "id": 1034972,
// "include_receipt": false,
// "invoiceid": null,
// "is_cogs": false,
// "isduplicate": false,
// "markup_percent": "0",
// "notes": "Need the parts to make the computer hardware",
// "profileid": null,
// "project": null,
// "projectid": 0,
// "staffid": 1,
// "status": 0,
// "taxAmount1": {
// "amount": "805.42",
// "code": "USD"
// },
// "taxAmount2": null,
// "taxName1": "HST",
// "taxName2": null,
// "taxPercent1": "13",
// "taxPercent2": null,
// "transactionid": null,
// "updated": "2019-04-18 09:41:44",
// "vendor": "Computer Parts People",
// "vis_state": 0
// },
// {
// "account_name": "",
// "accountid": null,
// "accounting_systemid": "wkMd2g",
// "amount": {
// "amount": "39.991",
// "code": "USD"
// },
// "attachment": null,
// "background_jobid": null,
// "bank_name": "",
// "category": {
// "category": "Equipment",
// "categoryid": 2003232,
// "created_at": "2019-04-18 09:14:52",
// "id": 2003232,
// "is_cogs": false,
// "is_editable": false,
// "parentid": 2003226,
// "updated_at": "2019-04-18 09:14:52",
// "vis_state": 0
// },
// "categoryid": 2003232,
// "clientid": 0,
// "compounded_tax": false,
// "date": "2018-06-20",
// "expense_profile": null,
// "expenseid": 1553548,
// "ext_invoiceid": 0,
// "ext_systemid": 0,
// "from_bulk_import": false,
// "has_receipt": false,
// "id": 1553548,
// "include_receipt": false,
// "invoiceid": null,
// "is_cogs": false,
// "isduplicate": false,
// "markup_percent": "0",
// "notes": "",
// "profileid": null,
// "project": null,
// "projectid": 0,
// "staffid": 31004,
// "status": 0,
// "taxAmount1": null,
// "taxAmount2": null,
// "taxName1": null,
// "taxName2": null,
// "taxPercent1": null,
// "taxPercent2": null,
// "transactionid": null,
// "updated": "2019-04-24 11:39:15",
// "vendor": null,
// "vis_state": 0
// }
// ],
// "page": 1,
// "pages": 1,
// "per_page": 15,
// "total": 5
// }
// }
// }
// Sample code for parsing the JSON response...
// Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
Get ComIntOf Of hoJResp "response.result.page" To iPage
Get ComIntOf Of hoJResp "response.result.pages" To iPages
Get ComIntOf Of hoJResp "response.result.per_page" To iPer_page
Get ComIntOf Of hoJResp "response.result.total" To iTotal
Move 0 To i
Get ComSizeOfArray Of hoJResp "response.result.expenses" To iCount_i
While (i < iCount_i)
Set ComI Of hoJResp To i
Get ComStringOf Of hoJResp "response.result.expenses[i].account_name" To sAccount_name
Get ComStringOf Of hoJResp "response.result.expenses[i].accountid" To sAccountid
Get ComStringOf Of hoJResp "response.result.expenses[i].accounting_systemid" To sAccounting_systemid
Get ComStringOf Of hoJResp "response.result.expenses[i].amount.amount" To sAmount
Get ComStringOf Of hoJResp "response.result.expenses[i].amount.code" To sCode
Get ComIntOf Of hoJResp "response.result.expenses[i].attachment.attachmentid" To iAttachmentid
Get ComIntOf Of hoJResp "response.result.expenses[i].attachment.id" To iId
Get ComStringOf Of hoJResp "response.result.expenses[i].attachment.jwt" To sV_Jwt
Get ComStringOf Of hoJResp "response.result.expenses[i].attachment.media_type" To sMedia_type
Get ComStringOf Of hoJResp "response.result.expenses[i].background_jobid" To sBackground_jobid
Get ComStringOf Of hoJResp "response.result.expenses[i].bank_name" To sBank_name
Get ComStringOf Of hoJResp "response.result.expenses[i].category.category" To sCategory
Get ComIntOf Of hoJResp "response.result.expenses[i].category.categoryid" To iCategoryid
Get ComStringOf Of hoJResp "response.result.expenses[i].category.created_at" To sCreated_at
Get ComIntOf Of hoJResp "response.result.expenses[i].category.id" To iCategoryId
Get ComBoolOf Of hoJResp "response.result.expenses[i].category.is_cogs" To iIs_cogs
Get ComBoolOf Of hoJResp "response.result.expenses[i].category.is_editable" To iIs_editable
Get ComIntOf Of hoJResp "response.result.expenses[i].category.parentid" To iParentid
Get ComStringOf Of hoJResp "response.result.expenses[i].category.updated_at" To sUpdated_at
Get ComIntOf Of hoJResp "response.result.expenses[i].category.vis_state" To iVis_state
Get ComIntOf Of hoJResp "response.result.expenses[i].categoryid" To iCategoryid
Get ComIntOf Of hoJResp "response.result.expenses[i].clientid" To iClientid
Get ComBoolOf Of hoJResp "response.result.expenses[i].compounded_tax" To iCompounded_tax
Get ComStringOf Of hoJResp "response.result.expenses[i].date" To sDate
Get ComStringOf Of hoJResp "response.result.expenses[i].expense_profile" To sExpense_profile
Get ComIntOf Of hoJResp "response.result.expenses[i].expenseid" To iExpenseid
Get ComIntOf Of hoJResp "response.result.expenses[i].ext_invoiceid" To iExt_invoiceid
Get ComIntOf Of hoJResp "response.result.expenses[i].ext_systemid" To iExt_systemid
Get ComBoolOf Of hoJResp "response.result.expenses[i].from_bulk_import" To iFrom_bulk_import
Get ComBoolOf Of hoJResp "response.result.expenses[i].has_receipt" To iHas_receipt
Get ComIntOf Of hoJResp "response.result.expenses[i].id" To iId
Get ComBoolOf Of hoJResp "response.result.expenses[i].include_receipt" To iInclude_receipt
Get ComStringOf Of hoJResp "response.result.expenses[i].invoiceid" To sInvoiceid
Get ComBoolOf Of hoJResp "response.result.expenses[i].is_cogs" To iIs_cogs
Get ComBoolOf Of hoJResp "response.result.expenses[i].isduplicate" To iIsduplicate
Get ComStringOf Of hoJResp "response.result.expenses[i].markup_percent" To sMarkup_percent
Get ComStringOf Of hoJResp "response.result.expenses[i].notes" To sNotes
Get ComStringOf Of hoJResp "response.result.expenses[i].profileid" To sProfileid
Get ComStringOf Of hoJResp "response.result.expenses[i].project" To sProject
Get ComIntOf Of hoJResp "response.result.expenses[i].projectid" To iProjectid
Get ComIntOf Of hoJResp "response.result.expenses[i].staffid" To iStaffid
Get ComIntOf Of hoJResp "response.result.expenses[i].status" To iStatus
Get ComStringOf Of hoJResp "response.result.expenses[i].taxAmount1.amount" To sTaxAmount1Amount
Get ComStringOf Of hoJResp "response.result.expenses[i].taxAmount1.code" To sTaxAmount1Code
Get ComStringOf Of hoJResp "response.result.expenses[i].taxAmount2" To sTaxAmount2
Get ComStringOf Of hoJResp "response.result.expenses[i].taxName1" To sTaxName1
Get ComStringOf Of hoJResp "response.result.expenses[i].taxName2" To sTaxName2
Get ComStringOf Of hoJResp "response.result.expenses[i].taxPercent1" To sTaxPercent1
Get ComStringOf Of hoJResp "response.result.expenses[i].taxPercent2" To sTaxPercent2
Get ComStringOf Of hoJResp "response.result.expenses[i].transactionid" To sTransactionid
Get ComStringOf Of hoJResp "response.result.expenses[i].updated" To sUpdated
Get ComStringOf Of hoJResp "response.result.expenses[i].vendor" To sVendor
Get ComIntOf Of hoJResp "response.result.expenses[i].vis_state" To iVis_state
Get ComStringOf Of hoJResp "response.result.expenses[i].attachment" To sAttachment
Get ComStringOf Of hoJResp "response.result.expenses[i].taxAmount1" To sTaxAmount1
Move (i + 1) To i
Loop
End_Procedure
Curl Command
curl -G -d "include[]=attachment"
-d "include[]=category"
-d "include[]=expense_profile"
-d "include[]=project"
-d "include[]=account"
-H "Authorization: Bearer <access_token>"
-H "Content-Type: application/json"
https://api.freshbooks.com/accounting/account/{{accountId}}/expenses/expenses
Postman Collection Item JSON
{
"name": "List Expenses",
"event": [
{
"listen": "test",
"script": {
"exec": [
"let jsonData = JSON.parse(responseBody);",
"pm.environment.set(\"expenseId\", jsonData.response.result.expenses[0].id)"
],
"type": "text/javascript"
}
}
],
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"url": {
"raw": "https://api.freshbooks.com/accounting/account/{{accountId}}/expenses/expenses?include[]=attachment&include[]=category&include[]=expense_profile&include[]=project&include[]=account",
"protocol": "https",
"host": [
"api",
"freshbooks",
"com"
],
"path": [
"accounting",
"account",
"{{accountId}}",
"expenses",
"expenses"
],
"query": [
{
"key": "include[]",
"value": "attachment",
"description": "includes attachment details assocatied with expense receipts"
},
{
"key": "include[]",
"value": "category",
"description": "include expense category in expense\n"
},
{
"key": "include[]",
"value": "expense_profile",
"description": "include expense profile info in expense\n"
},
{
"key": "include[]",
"value": "project",
"description": "include related projects in expense\n"
},
{
"key": "include[]",
"value": "account",
"description": "include account info in expense\n"
}
]
},
"description": "Get all expenses\t"
},
"response": [
{
"name": "List Expenses",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"url": {
"raw": "https://api.freshbooks.com/accounting/account/{{accountId}}/expenses/expenses?include%5B%5D=attachment&include%5B%5D=category&include%5B%5D=expense_profile&include%5B%5D=project&include%5B%5D=account",
"protocol": "https",
"host": [
"api",
"freshbooks",
"com"
],
"path": [
"accounting",
"account",
"{{accountId}}",
"expenses",
"expenses"
],
"query": [
{
"key": "include%5B%5D",
"value": "attachment",
"description": "includes attachment details assocatied with expense receipts"
},
{
"key": "include%5B%5D",
"value": "category",
"description": "include expense category in expense\n"
},
{
"key": "include%5B%5D",
"value": "expense_profile",
"description": "include expense profile info in expense\n"
},
{
"key": "include%5B%5D",
"value": "project",
"description": "include related projects in expense\n"
},
{
"key": "include%5B%5D",
"value": "account",
"description": "include account info in expense\n"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Server",
"value": "nginx"
},
{
"key": "Content-Type",
"value": "application/json"
},
{
"key": "X-NewRelic-App-Data",
"value": "PxQBWV5TCBABVlVSAwEOVlcTGhE1AwE2QgNWEVlbQFtcCxYnRA9QFg1ZWU4DFVdfRgFPCkNFR0gBSUZWDBUGEQoHQBJdVkdXQEcVUR1RHVNWBw9UVVsKCwRXUVMABABeSBwHH0BXW1EBB1tbXQtVUAQAXFgBQx8EBVpEBDs="
},
{
"key": "Access-Control-Allow-Origin",
"value": "*"
},
{
"key": "Expires",
"value": "Mon, 30 Apr 2018 21:04:15 GMT"
},
{
"key": "Cache-Control",
"value": "no-cache"
},
{
"key": "Content-Encoding",
"value": "gzip"
},
{
"key": "Via",
"value": "1.1 google"
},
{
"key": "Via",
"value": "1.1 varnish"
},
{
"key": "Accept-Ranges",
"value": "bytes"
},
{
"key": "Accept-Ranges",
"value": "bytes"
},
{
"key": "Age",
"value": "0"
},
{
"key": "Age",
"value": "0"
},
{
"key": "Transfer-Encoding",
"value": "chunked"
},
{
"key": "Date",
"value": "Tue, 30 Apr 2019 21:04:16 GMT"
},
{
"key": "Connection",
"value": "keep-alive"
},
{
"key": "X-Served-By",
"value": "cache-mdw17339-MDW"
},
{
"key": "X-Cache",
"value": "MISS"
},
{
"key": "X-Cache-Hits",
"value": "0"
},
{
"key": "Vary",
"value": "Accept-Encoding"
},
{
"key": "Country",
"value": "CA"
},
{
"key": "Strict-Transport-Security",
"value": "max-age=31536000; includeSubDomains; preload"
}
],
"cookie": [
],
"body": "{\n \"response\": {\n \"result\": {\n \"expenses\": [\n {\n \"account_name\": \"\",\n \"accountid\": null,\n \"accounting_systemid\": \"wkMd2g\",\n \"amount\": {\n \"amount\": \"79.73\",\n \"code\": \"USD\"\n },\n \"attachment\": {\n \"attachmentid\": 8668,\n \"id\": 8668,\n \"jwt\": \"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhY2NvdW50Ijo0MjM2NDEwLCJvcmlnaW5hbF9maWxlbmFtZSI6IlNjcmVlbiBTaG90IDIwMTktMDQtMjQgYXQgOS4zOS4xOSBBTS5wbmciLCJidWNrZXQiOiJ1cGxvYWRzIiwiZmlsZW5hbWUiOiJ1cGxvYWQtMGU2ZDMwOWQ1ZTI5MzA3NmNhMGIyNDdkODFlOGJlNWE4NDZlZWE0YSIsImxlbmd0aCI6MTkxNDcyLCJrZXkiOiInZG9jcy0nLTQyMzY0MTAvdXBsb2FkLTBlNmQzMDlkNWUyOTMwNzZjYTBiMjQ3ZDgxZThiZTVhODQ2ZWVhNGEifQ.SOoW3_nTUrxjYO76g1UXHPIrO_aLbTpXCHEa-ZcnejA\",\n \"media_type\": \"image/png\"\n },\n \"background_jobid\": null,\n \"bank_name\": \"\",\n \"category\": {\n \"category\": \"Gas\",\n \"categoryid\": 2003174,\n \"created_at\": \"2019-04-18 09:14:52\",\n \"id\": 2003174,\n \"is_cogs\": false,\n \"is_editable\": false,\n \"parentid\": 2003170,\n \"updated_at\": \"2019-04-18 09:14:52\",\n \"vis_state\": 0\n },\n \"categoryid\": 2003174,\n \"clientid\": 0,\n \"compounded_tax\": false,\n \"date\": \"2019-04-24\",\n \"expense_profile\": null,\n \"expenseid\": 1825568,\n \"ext_invoiceid\": 0,\n \"ext_systemid\": 0,\n \"from_bulk_import\": false,\n \"has_receipt\": true,\n \"id\": 1825568,\n \"include_receipt\": false,\n \"invoiceid\": null,\n \"is_cogs\": false,\n \"isduplicate\": true,\n \"markup_percent\": \"0\",\n \"notes\": \"Purchased Gasoline for deliveries\",\n \"profileid\": null,\n \"project\": null,\n \"projectid\": 0,\n \"staffid\": 1,\n \"status\": 0,\n \"taxAmount1\": {\n \"amount\": \"9.17\",\n \"code\": \"USD\"\n },\n \"taxAmount2\": null,\n \"taxName1\": \"other tax\",\n \"taxName2\": null,\n \"taxPercent1\": \"13\",\n \"taxPercent2\": null,\n \"transactionid\": null,\n \"updated\": \"2019-04-24 11:33:35\",\n \"vendor\": \"Shell Gas Station\",\n \"vis_state\": 0\n },\n {\n \"account_name\": \"\",\n \"accountid\": null,\n \"accounting_systemid\": \"wkMd2g\",\n \"amount\": {\n \"amount\": \"79.73\",\n \"code\": \"USD\"\n },\n \"attachment\": {\n \"attachmentid\": 8670,\n \"id\": 8670,\n \"jwt\": \"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhY2NvdW50Ijo0MjM2NDEwLCJvcmlnaW5hbF9maWxlbmFtZSI6IlNjcmVlbiBTaG90IDIwMTktMDQtMjQgYXQgOS4zOS4xOSBBTS5wbmciLCJidWNrZXQiOiJ1cGxvYWRzIiwiZmlsZW5hbWUiOiJ1cGxvYWQtMGU2ZDMwOWQ1ZTI5MzA3NmNhMGIyNDdkODFlOGJlNWE4NDZlZWE0YSIsImxlbmd0aCI6MTkxNDcyLCJrZXkiOiInZG9jcy0nLTQyMzY0MTAvdXBsb2FkLTBlNmQzMDlkNWUyOTMwNzZjYTBiMjQ3ZDgxZThiZTVhODQ2ZWVhNGEifQ.SOoW3_nTUrxjYO76g1UXHPIrO_aLbTpXCHEa-ZcnejA\",\n \"media_type\": \"image/png\"\n },\n \"background_jobid\": null,\n \"bank_name\": \"\",\n \"category\": {\n \"category\": \"Gas\",\n \"categoryid\": 2003174,\n \"created_at\": \"2019-04-18 09:14:52\",\n \"id\": 2003174,\n \"is_cogs\": false,\n \"is_editable\": false,\n \"parentid\": 2003170,\n \"updated_at\": \"2019-04-18 09:14:52\",\n \"vis_state\": 0\n },\n \"categoryid\": 2003174,\n \"clientid\": 0,\n \"compounded_tax\": false,\n \"date\": \"2019-04-24\",\n \"expense_profile\": null,\n \"expenseid\": 1825574,\n \"ext_invoiceid\": 0,\n \"ext_systemid\": 0,\n \"from_bulk_import\": false,\n \"has_receipt\": true,\n \"id\": 1825574,\n \"include_receipt\": false,\n \"invoiceid\": null,\n \"is_cogs\": false,\n \"isduplicate\": true,\n \"markup_percent\": \"0\",\n \"notes\": \"Purchased Gasoline for deliveries\",\n \"profileid\": null,\n \"project\": null,\n \"projectid\": 0,\n \"staffid\": 1,\n \"status\": 0,\n \"taxAmount1\": {\n \"amount\": \"9.17\",\n \"code\": \"USD\"\n },\n \"taxAmount2\": null,\n \"taxName1\": \"other tax\",\n \"taxName2\": null,\n \"taxPercent1\": \"13\",\n \"taxPercent2\": null,\n \"transactionid\": null,\n \"updated\": \"2019-04-24 11:38:00\",\n \"vendor\": \"Shell Gas Station\",\n \"vis_state\": 2\n },\n {\n \"account_name\": \"\",\n \"accountid\": null,\n \"accounting_systemid\": \"wkMd2g\",\n \"amount\": {\n \"amount\": \"79.73\",\n \"code\": \"USD\"\n },\n \"attachment\": {\n \"attachmentid\": 12138,\n \"id\": 12138,\n \"jwt\": \"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhY2NvdW50Ijo0MjM2NDEwLCJvcmlnaW5hbF9maWxlbmFtZSI6IlNjcmVlbiBTaG90IDIwMTktMDQtMjQgYXQgOS4zOS4xOSBBTS5wbmciLCJidWNrZXQiOiJ1cGxvYWRzIiwiZmlsZW5hbWUiOiJ1cGxvYWQtMGU2ZDMwOWQ1ZTI5MzA3NmNhMGIyNDdkODFlOGJlNWE4NDZlZWE0YSIsImxlbmd0aCI6MTkxNDcyLCJrZXkiOiInZG9jcy0nLTQyMzY0MTAvdXBsb2FkLTBlNmQzMDlkNWUyOTMwNzZjYTBiMjQ3ZDgxZThiZTVhODQ2ZWVhNGEifQ.SOoW3_nTUrxjYO76g1UXHPIrO_aLbTpXCHEa-ZcnejA\",\n \"media_type\": \"image/png\"\n },\n \"background_jobid\": null,\n \"bank_name\": \"\",\n \"category\": {\n \"category\": \"Gas\",\n \"categoryid\": 2003174,\n \"created_at\": \"2019-04-18 09:14:52\",\n \"id\": 2003174,\n \"is_cogs\": false,\n \"is_editable\": false,\n \"parentid\": 2003170,\n \"updated_at\": \"2019-04-18 09:14:52\",\n \"vis_state\": 0\n },\n \"categoryid\": 2003174,\n \"clientid\": 0,\n \"compounded_tax\": false,\n \"date\": \"2019-04-24\",\n \"expense_profile\": null,\n \"expenseid\": 2721846,\n \"ext_invoiceid\": 0,\n \"ext_systemid\": 0,\n \"from_bulk_import\": false,\n \"has_receipt\": true,\n \"id\": 2721846,\n \"include_receipt\": false,\n \"invoiceid\": null,\n \"is_cogs\": false,\n \"isduplicate\": true,\n \"markup_percent\": \"0\",\n \"notes\": \"Purchased Gasoline for deliveries\",\n \"profileid\": null,\n \"project\": null,\n \"projectid\": 0,\n \"staffid\": 1,\n \"status\": 0,\n \"taxAmount1\": {\n \"amount\": \"9.17\",\n \"code\": \"USD\"\n },\n \"taxAmount2\": null,\n \"taxName1\": \"other tax\",\n \"taxName2\": null,\n \"taxPercent1\": \"13\",\n \"taxPercent2\": null,\n \"transactionid\": null,\n \"updated\": \"2019-04-30 16:48:22\",\n \"vendor\": \"Shell Gas Station\",\n \"vis_state\": 0\n },\n {\n \"account_name\": \"\",\n \"accountid\": null,\n \"accounting_systemid\": \"wkMd2g\",\n \"amount\": {\n \"amount\": \"7000.99\",\n \"code\": \"USD\"\n },\n \"attachment\": {\n \"attachmentid\": 6122,\n \"id\": 6122,\n \"jwt\": \"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhY2NvdW50Ijo0MjM2NDEwLCJvcmlnaW5hbF9maWxlbmFtZSI6IlNjcmVlbiBTaG90IDIwMTktMDQtMTYgYXQgMTEuMzcuMjEgQU0ucG5nIiwiYnVja2V0IjoidXBsb2FkcyIsImZpbGVuYW1lIjoidXBsb2FkLTJjMDY0NDEwZDQwYjE1NTRkZTAyM2Q1MjNlNmJjOTA3NDMyYmIwMGMiLCJsZW5ndGgiOjE0NTk2MCwia2V5IjoiJ2RvY3MtJy00MjM2NDEwL3VwbG9hZC0yYzA2NDQxMGQ0MGIxNTU0ZGUwMjNkNTIzZTZiYzkwNzQzMmJiMDBjIn0.MogtZWv_c3mllnjMzX5DEP2J5PBsEa1ZfHwdXgywRoM\",\n \"media_type\": \"image/png\"\n },\n \"background_jobid\": null,\n \"bank_name\": \"\",\n \"category\": {\n \"category\": \"Computer Parts\",\n \"categoryid\": 2005674,\n \"created_at\": \"2019-04-18 09:40:57\",\n \"id\": 2005674,\n \"is_cogs\": false,\n \"is_editable\": true,\n \"parentid\": 2003142,\n \"updated_at\": \"2019-04-18 09:40:57\",\n \"vis_state\": 0\n },\n \"categoryid\": 2005674,\n \"clientid\": 0,\n \"compounded_tax\": false,\n \"date\": \"2019-04-18\",\n \"expense_profile\": null,\n \"expenseid\": 1034972,\n \"ext_invoiceid\": 0,\n \"ext_systemid\": 0,\n \"from_bulk_import\": false,\n \"has_receipt\": true,\n \"id\": 1034972,\n \"include_receipt\": false,\n \"invoiceid\": null,\n \"is_cogs\": false,\n \"isduplicate\": false,\n \"markup_percent\": \"0\",\n \"notes\": \"Need the parts to make the computer hardware\",\n \"profileid\": null,\n \"project\": null,\n \"projectid\": 0,\n \"staffid\": 1,\n \"status\": 0,\n \"taxAmount1\": {\n \"amount\": \"805.42\",\n \"code\": \"USD\"\n },\n \"taxAmount2\": null,\n \"taxName1\": \"HST\",\n \"taxName2\": null,\n \"taxPercent1\": \"13\",\n \"taxPercent2\": null,\n \"transactionid\": null,\n \"updated\": \"2019-04-18 09:41:44\",\n \"vendor\": \"Computer Parts People\",\n \"vis_state\": 0\n },\n {\n \"account_name\": \"\",\n \"accountid\": null,\n \"accounting_systemid\": \"wkMd2g\",\n \"amount\": {\n \"amount\": \"39.991\",\n \"code\": \"USD\"\n },\n \"attachment\": null,\n \"background_jobid\": null,\n \"bank_name\": \"\",\n \"category\": {\n \"category\": \"Equipment\",\n \"categoryid\": 2003232,\n \"created_at\": \"2019-04-18 09:14:52\",\n \"id\": 2003232,\n \"is_cogs\": false,\n \"is_editable\": false,\n \"parentid\": 2003226,\n \"updated_at\": \"2019-04-18 09:14:52\",\n \"vis_state\": 0\n },\n \"categoryid\": 2003232,\n \"clientid\": 0,\n \"compounded_tax\": false,\n \"date\": \"2018-06-20\",\n \"expense_profile\": null,\n \"expenseid\": 1553548,\n \"ext_invoiceid\": 0,\n \"ext_systemid\": 0,\n \"from_bulk_import\": false,\n \"has_receipt\": false,\n \"id\": 1553548,\n \"include_receipt\": false,\n \"invoiceid\": null,\n \"is_cogs\": false,\n \"isduplicate\": false,\n \"markup_percent\": \"0\",\n \"notes\": \"\",\n \"profileid\": null,\n \"project\": null,\n \"projectid\": 0,\n \"staffid\": 31004,\n \"status\": 0,\n \"taxAmount1\": null,\n \"taxAmount2\": null,\n \"taxName1\": null,\n \"taxName2\": null,\n \"taxPercent1\": null,\n \"taxPercent2\": null,\n \"transactionid\": null,\n \"updated\": \"2019-04-24 11:39:15\",\n \"vendor\": null,\n \"vis_state\": 0\n }\n ],\n \"page\": 1,\n \"pages\": 1,\n \"per_page\": 15,\n \"total\": 5\n }\n }\n}"
}
]
}
