PowerBuilder / New FreshBooks / Create Invoice with Expense
Back to Collection Items
integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Json
oleobject loo_Resp
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat_9_5_0.Http")
if li_rc < 0 then
destroy loo_Http
MessageBox("Error","Connecting to COM object failed")
return
end if
// Use this online tool to generate code from sample JSON: Generate Code to Create JSON
// The following JSON is sent in the request body.
// {
// "invoice": {
// "customerid": 485558,
// "create_date": "2019-06-20",
// "lines": [
// {
// "type": 0,
// "description": "",
// "taxName1": "",
// "taxAmount1": 0,
// "name": "Paperwork",
// "qty": 1,
// "taxName2": "",
// "taxAmount2": 0,
// "unit_cost": {
// "amount": "5000.00",
// "code": "USD"
// }
// },
// {
// "type": 1,
// "description": "Gas",
// "expenseid": 123,
// "taxName1": "",
// "taxAmount1": 0,
// "name": "Shell Oil",
// "qty": 1,
// "taxName2": "",
// "taxAmount2": 0,
// "unit_cost": {
// "amount": "120.00",
// "code": "USD"
// }
// }
// ]
// }
// }
loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat_9_5_0.JsonObject")
loo_Json.UpdateInt("invoice.customerid",485558)
loo_Json.UpdateString("invoice.create_date","2019-06-20")
loo_Json.UpdateInt("invoice.lines[0].type",0)
loo_Json.UpdateString("invoice.lines[0].description","")
loo_Json.UpdateString("invoice.lines[0].taxName1","")
loo_Json.UpdateInt("invoice.lines[0].taxAmount1",0)
loo_Json.UpdateString("invoice.lines[0].name","Paperwork")
loo_Json.UpdateInt("invoice.lines[0].qty",1)
loo_Json.UpdateString("invoice.lines[0].taxName2","")
loo_Json.UpdateInt("invoice.lines[0].taxAmount2",0)
loo_Json.UpdateString("invoice.lines[0].unit_cost.amount","5000.00")
loo_Json.UpdateString("invoice.lines[0].unit_cost.code","USD")
loo_Json.UpdateInt("invoice.lines[1].type",1)
loo_Json.UpdateString("invoice.lines[1].description","Gas")
loo_Json.UpdateInt("invoice.lines[1].expenseid",123)
loo_Json.UpdateString("invoice.lines[1].taxName1","")
loo_Json.UpdateInt("invoice.lines[1].taxAmount1",0)
loo_Json.UpdateString("invoice.lines[1].name","Shell Oil")
loo_Json.UpdateInt("invoice.lines[1].qty",1)
loo_Json.UpdateString("invoice.lines[1].taxName2","")
loo_Json.UpdateInt("invoice.lines[1].taxAmount2",0)
loo_Json.UpdateString("invoice.lines[1].unit_cost.amount","120.00")
loo_Json.UpdateString("invoice.lines[1].unit_cost.code","USD")
// Adds the "Authorization: Bearer <access_token>" header.
loo_Http.AuthToken = "<access_token>"
loo_Http.SetRequestHeader("Content-Type","application/json")
loo_Resp = loo_Http.PostJson3("https://api.freshbooks.com/accounting/account/{{accountId}}/invoices/invoices","application/json",loo_Json)
if loo_Http.LastMethodSuccess = 0 then
Write-Debug loo_Http.LastErrorText
destroy loo_Http
destroy loo_Json
return
end if
Write-Debug string(loo_Resp.StatusCode)
Write-Debug loo_Resp.BodyStr
destroy loo_Resp
destroy loo_Http
destroy loo_Json
Curl Command
curl -X POST
-H "Authorization: Bearer <access_token>"
-H "Content-Type: application/json"
-d '{
"invoice": {
"customerid": 485558,
"create_date": "2019-06-20",
"lines": [
{
"type": 0,
"description": "",
"taxName1": "",
"taxAmount1": 0,
"name": "Paperwork",
"qty": 1,
"taxName2": "",
"taxAmount2": 0,
"unit_cost": {
"amount": "5000.00",
"code": "USD"
}
},
{
"type": 1,
"description": "Gas",
"expenseid": {{expenseId}},
"taxName1": "",
"taxAmount1": 0,
"name": "Shell Oil",
"qty": 1,
"taxName2": "",
"taxAmount2": 0,
"unit_cost": {
"amount": "120.00",
"code": "USD"
}
}
]
}
}'
https://api.freshbooks.com/accounting/account/{{accountId}}/invoices/invoices
Postman Collection Item JSON
{
"name": "Create Invoice with Expense ",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"invoice\": {\n \"customerid\": 485558,\n \"create_date\": \"2019-06-20\",\n \"lines\": [\n {\n \"type\": 0,\n \"description\": \"\",\n \"taxName1\": \"\",\n \"taxAmount1\": 0,\n \"name\": \"Paperwork\",\n \"qty\": 1,\n \"taxName2\": \"\",\n \"taxAmount2\": 0,\n \"unit_cost\": {\n \"amount\": \"5000.00\",\n \"code\": \"USD\"\n }\n },\n {\n \"type\": 1,\n \"description\": \"Gas\",\n \"expenseid\": {{expenseId}},\n \"taxName1\": \"\",\n \"taxAmount1\": 0,\n \"name\": \"Shell Oil\",\n \"qty\": 1,\n \"taxName2\": \"\",\n \"taxAmount2\": 0,\n \"unit_cost\": {\n \"amount\": \"120.00\",\n \"code\": \"USD\"\n }\n }\n ]\n }\n}\n"
},
"url": {
"raw": "https://api.freshbooks.com/accounting/account/{{accountId}}/invoices/invoices",
"protocol": "https",
"host": [
"api",
"freshbooks",
"com"
],
"path": [
"accounting",
"account",
"{{accountId}}",
"invoices",
"invoices"
]
},
"description": "Creating invoice with expense.\n\nFirst you will need to create an expense. Once that is created, save the expenseId and add it to the invoice. \n\nWhen adding an expense, make sure you add to the `markup_percent` parameter the amount you want to markup by and set `cogs` to `true` if it is an item you have paid for. "
},
"response": [
]
}
