Foxpro / New FreshBooks / Create Single Invoice Profile w/ Time Entry Holder
Back to Collection Items
LOCAL loHttp
LOCAL lnSuccess
LOCAL loJson
LOCAL loResp
* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.
loHttp = CreateObject('Chilkat_9_5_0.Http')
* 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_profile": {
* "customerid": 123,
* "frequency": "m",
* "profileid": null,
* "disable": false,
* "due_offset_days": 30,
* "numberRecurring": 0,
* "send_email": true,
* "include_unbilled_time": true,
* "project_format": {
* "group_by": "service",
* "method": "detailed",
* "show_tname": true,
* "show_pname": true,
* "show_staff": true,
* "show_date": true,
* "show_notes": true,
* "show_total_hours": false
* },
* "skip_generation": false,
* "retainer_id": null,
* "require_auto_bill": false,
* "create_date": "2019-07-15",
* "currency_code": "CAD",
* "discount_value": 0,
* "template": "clean-grouped",
* "terms": "Show me the money",
* "allowed_gatewayids": [
* 26
* ],
* "late_fee": {
* "compounded_taxes": false,
* "days": 30,
* "enabled": false,
* "first_tax_name": "HST",
* "first_tax_percent": 13,
* "repeat": false,
* "second_tax_name": null,
* "second_tax_percent": null,
* "type": "percent",
* "value": 10
* },
* "late_reminders": [
* ],
* "lines": [
* {
* "amount": {
* "amount": "0",
* "code": "CAD"
* },
* "description": null,
* "expenseid": null,
* "taxName1": null,
* "taxAmount1": 0,
* "name": null,
* "qty": 1,
* "taxName2": null,
* "taxAmount2": 0,
* "type": 5,
* "unit_cost": {
* "amount": "0",
* "code": "CAD"
* },
* "profileid": null
* }
* ]
* }
* }
loJson = CreateObject('Chilkat_9_5_0.JsonObject')
loJson.UpdateInt("invoice_profile.customerid",123)
loJson.UpdateString("invoice_profile.frequency","m")
loJson.UpdateNull("invoice_profile.profileid")
loJson.UpdateBool("invoice_profile.disable",0)
loJson.UpdateInt("invoice_profile.due_offset_days",30)
loJson.UpdateInt("invoice_profile.numberRecurring",0)
loJson.UpdateBool("invoice_profile.send_email",1)
loJson.UpdateBool("invoice_profile.include_unbilled_time",1)
loJson.UpdateString("invoice_profile.project_format.group_by","service")
loJson.UpdateString("invoice_profile.project_format.method","detailed")
loJson.UpdateBool("invoice_profile.project_format.show_tname",1)
loJson.UpdateBool("invoice_profile.project_format.show_pname",1)
loJson.UpdateBool("invoice_profile.project_format.show_staff",1)
loJson.UpdateBool("invoice_profile.project_format.show_date",1)
loJson.UpdateBool("invoice_profile.project_format.show_notes",1)
loJson.UpdateBool("invoice_profile.project_format.show_total_hours",0)
loJson.UpdateBool("invoice_profile.skip_generation",0)
loJson.UpdateNull("invoice_profile.retainer_id")
loJson.UpdateBool("invoice_profile.require_auto_bill",0)
loJson.UpdateString("invoice_profile.create_date","2019-07-15")
loJson.UpdateString("invoice_profile.currency_code","CAD")
loJson.UpdateInt("invoice_profile.discount_value",0)
loJson.UpdateString("invoice_profile.template","clean-grouped")
loJson.UpdateString("invoice_profile.terms","Show me the money")
loJson.UpdateInt("invoice_profile.allowed_gatewayids[0]",26)
loJson.UpdateBool("invoice_profile.late_fee.compounded_taxes",0)
loJson.UpdateInt("invoice_profile.late_fee.days",30)
loJson.UpdateBool("invoice_profile.late_fee.enabled",0)
loJson.UpdateString("invoice_profile.late_fee.first_tax_name","HST")
loJson.UpdateInt("invoice_profile.late_fee.first_tax_percent",13)
loJson.UpdateBool("invoice_profile.late_fee.repeat",0)
loJson.UpdateNull("invoice_profile.late_fee.second_tax_name")
loJson.UpdateNull("invoice_profile.late_fee.second_tax_percent")
loJson.UpdateString("invoice_profile.late_fee.type","percent")
loJson.UpdateInt("invoice_profile.late_fee.value",10)
loJson.UpdateNewArray("invoice_profile.late_reminders")
loJson.UpdateString("invoice_profile.lines[0].amount.amount","0")
loJson.UpdateString("invoice_profile.lines[0].amount.code","CAD")
loJson.UpdateNull("invoice_profile.lines[0].description")
loJson.UpdateNull("invoice_profile.lines[0].expenseid")
loJson.UpdateNull("invoice_profile.lines[0].taxName1")
loJson.UpdateInt("invoice_profile.lines[0].taxAmount1",0)
loJson.UpdateNull("invoice_profile.lines[0].name")
loJson.UpdateInt("invoice_profile.lines[0].qty",1)
loJson.UpdateNull("invoice_profile.lines[0].taxName2")
loJson.UpdateInt("invoice_profile.lines[0].taxAmount2",0)
loJson.UpdateInt("invoice_profile.lines[0].type",5)
loJson.UpdateString("invoice_profile.lines[0].unit_cost.amount","0")
loJson.UpdateString("invoice_profile.lines[0].unit_cost.code","CAD")
loJson.UpdateNull("invoice_profile.lines[0].profileid")
* Adds the "Authorization: Bearer <access_token>" header.
loHttp.AuthToken = "<access_token>"
loHttp.SetRequestHeader("Content-Type","application/json")
loResp = loHttp.PostJson3("https://api.freshbooks.com/accounting/account/{{accountid}}/invoice_profiles/invoice_profiles?include[]=allowed_gateways,contacts,late_fee,late_reminders,lines,presentation,system,tracking,project_format,total_accrued_revenue&include%5B%5D=allowed_gateways,contacts,late_fee,late_reminders,lines,presentation,system,tracking,project_format,total_accrued_revenue","application/json",loJson)
IF (loHttp.LastMethodSuccess = 0) THEN
? loHttp.LastErrorText
RELEASE loHttp
RELEASE loJson
CANCEL
ENDIF
? STR(loResp.StatusCode)
? loResp.BodyStr
RELEASE loResp
RELEASE loHttp
RELEASE loJson
Curl Command
curl -X POST
-H "Authorization: Bearer <access_token>"
-H "Content-Type: application/json"
-d '{
"invoice_profile":
{
"customerid": {{customerid}},
"frequency":"m",
"profileid":null,
"disable":false,
"due_offset_days":30,
"numberRecurring":0,
"send_email":true,
"include_unbilled_time":true,
"project_format":
{
"group_by":"service",
"method":"detailed",
"show_tname":true,
"show_pname":true,
"show_staff":true,
"show_date":true,
"show_notes":true,
"show_total_hours":false
},
"skip_generation":false,
"retainer_id":null,
"require_auto_bill":false,
"create_date":"2019-07-15",
"currency_code":"CAD",
"discount_value":0,
"template":"clean-grouped",
"terms": "Show me the money",
"allowed_gatewayids":[26],
"late_fee":
{
"compounded_taxes":false,
"days":30,
"enabled":false,
"first_tax_name": "HST",
"first_tax_percent": 13,
"repeat":false,
"second_tax_name":null,
"second_tax_percent":null,
"type":"percent",
"value":10}
,"late_reminders":[],
"lines":
[{
"amount":
{
"amount":"0",
"code":"CAD"
},
"description":null,
"expenseid":null,
"taxName1":null,
"taxAmount1":0,
"name":null,
"qty":1,
"taxName2":null,
"taxAmount2":0,
"type":5,
"unit_cost":
{
"amount":"0",
"code":"CAD"
},
"profileid":null
}]
}
}'
https://api.freshbooks.com/accounting/account/{{accountid}}/invoice_profiles/invoice_profiles?include[]=allowed_gateways,contacts,late_fee,late_reminders,lines,presentation,system,tracking,project_format,total_accrued_revenue&include%5B%5D=allowed_gateways,contacts,late_fee,late_reminders,lines,presentation,system,tracking,project_format,total_accrued_revenue
Postman Collection Item JSON
{
"name": "Create Single Invoice Profile w/ Time Entry Holder ",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"invoice_profile\":\n {\n \"customerid\": {{customerid}},\n \"frequency\":\"m\",\n \"profileid\":null,\n \"disable\":false,\n \"due_offset_days\":30,\n \"numberRecurring\":0,\n \"send_email\":true,\n \"include_unbilled_time\":true,\n \"project_format\":\n {\n \"group_by\":\"service\",\n \"method\":\"detailed\",\n \"show_tname\":true,\n \"show_pname\":true,\n \"show_staff\":true,\n \"show_date\":true,\n \"show_notes\":true,\n \"show_total_hours\":false\n },\n \"skip_generation\":false,\n \"retainer_id\":null,\n \"require_auto_bill\":false,\n \"create_date\":\"2019-07-15\",\n \"currency_code\":\"CAD\",\n \"discount_value\":0,\n \"template\":\"clean-grouped\",\n \"terms\": \"Show me the money\",\n \"allowed_gatewayids\":[26],\n \"late_fee\":\n {\n \"compounded_taxes\":false,\n \"days\":30,\n \"enabled\":false,\n \"first_tax_name\": \"HST\",\n \"first_tax_percent\": 13,\n \"repeat\":false,\n \"second_tax_name\":null,\n \"second_tax_percent\":null,\n \"type\":\"percent\",\n \"value\":10}\n ,\"late_reminders\":[],\n \"lines\":\n [{\n \"amount\":\n {\n \"amount\":\"0\",\n \"code\":\"CAD\"\n },\n \"description\":null,\n \"expenseid\":null,\n \"taxName1\":null,\n \"taxAmount1\":0,\n \"name\":null,\n \"qty\":1,\n \"taxName2\":null,\n \"taxAmount2\":0,\n \"type\":5,\n \"unit_cost\":\n {\n \"amount\":\"0\",\n \"code\":\"CAD\"\n },\n \"profileid\":null\n }]\n }\n}"
},
"url": {
"raw": "https://api.freshbooks.com/accounting/account/{{accountid}}/invoice_profiles/invoice_profiles?include[]=allowed_gateways,contacts,late_fee,late_reminders,lines,presentation,system,tracking,project_format,total_accrued_revenue&include%5B%5D=allowed_gateways,contacts,late_fee,late_reminders,lines,presentation,system,tracking,project_format,total_accrued_revenue",
"protocol": "https",
"host": [
"api",
"freshbooks",
"com"
],
"path": [
"accounting",
"account",
"{{accountid}}",
"invoice_profiles",
"invoice_profiles"
],
"query": [
{
"key": "include[]",
"value": "allowed_gateways,contacts,late_fee,late_reminders,lines,presentation,system,tracking,project_format,total_accrued_revenue"
},
{
"key": "include%5B%5D",
"value": "allowed_gateways,contacts,late_fee,late_reminders,lines,presentation,system,tracking,project_format,total_accrued_revenue"
}
]
},
"description": "This will create an invoice profile that will pull unbilled time entries for your client on to the invoice that is generated"
},
"response": [
]
}
