DataFlex / New FreshBooks / Create Single Invoice Profile w/ Time Entry Holder
Back to Collection Items
Use ChilkatAx-win32.pkg
Procedure Test
Handle hoHttp
Boolean iSuccess
Variant vJson
Handle hoJson
Variant vResp
Handle hoResp
String sTemp1
Integer iTemp1
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
// 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
// }
// ]
// }
// }
Get Create (RefClass(cComChilkatJsonObject)) To hoJson
If (Not(IsComObjectCreated(hoJson))) Begin
Send CreateComObject of hoJson
End
Get ComUpdateInt Of hoJson "invoice_profile.customerid" 123 To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.frequency" "m" To iSuccess
Get ComUpdateNull Of hoJson "invoice_profile.profileid" To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.disable" False To iSuccess
Get ComUpdateInt Of hoJson "invoice_profile.due_offset_days" 30 To iSuccess
Get ComUpdateInt Of hoJson "invoice_profile.numberRecurring" 0 To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.send_email" True To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.include_unbilled_time" True To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.project_format.group_by" "service" To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.project_format.method" "detailed" To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.project_format.show_tname" True To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.project_format.show_pname" True To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.project_format.show_staff" True To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.project_format.show_date" True To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.project_format.show_notes" True To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.project_format.show_total_hours" False To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.skip_generation" False To iSuccess
Get ComUpdateNull Of hoJson "invoice_profile.retainer_id" To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.require_auto_bill" False To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.create_date" "2019-07-15" To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.currency_code" "CAD" To iSuccess
Get ComUpdateInt Of hoJson "invoice_profile.discount_value" 0 To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.template" "clean-grouped" To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.terms" "Show me the money" To iSuccess
Get ComUpdateInt Of hoJson "invoice_profile.allowed_gatewayids[0]" 26 To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.late_fee.compounded_taxes" False To iSuccess
Get ComUpdateInt Of hoJson "invoice_profile.late_fee.days" 30 To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.late_fee.enabled" False To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.late_fee.first_tax_name" "HST" To iSuccess
Get ComUpdateInt Of hoJson "invoice_profile.late_fee.first_tax_percent" 13 To iSuccess
Get ComUpdateBool Of hoJson "invoice_profile.late_fee.repeat" False To iSuccess
Get ComUpdateNull Of hoJson "invoice_profile.late_fee.second_tax_name" To iSuccess
Get ComUpdateNull Of hoJson "invoice_profile.late_fee.second_tax_percent" To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.late_fee.type" "percent" To iSuccess
Get ComUpdateInt Of hoJson "invoice_profile.late_fee.value" 10 To iSuccess
Get ComUpdateNewArray Of hoJson "invoice_profile.late_reminders" To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.lines[0].amount.amount" "0" To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.lines[0].amount.code" "CAD" To iSuccess
Get ComUpdateNull Of hoJson "invoice_profile.lines[0].description" To iSuccess
Get ComUpdateNull Of hoJson "invoice_profile.lines[0].expenseid" To iSuccess
Get ComUpdateNull Of hoJson "invoice_profile.lines[0].taxName1" To iSuccess
Get ComUpdateInt Of hoJson "invoice_profile.lines[0].taxAmount1" 0 To iSuccess
Get ComUpdateNull Of hoJson "invoice_profile.lines[0].name" To iSuccess
Get ComUpdateInt Of hoJson "invoice_profile.lines[0].qty" 1 To iSuccess
Get ComUpdateNull Of hoJson "invoice_profile.lines[0].taxName2" To iSuccess
Get ComUpdateInt Of hoJson "invoice_profile.lines[0].taxAmount2" 0 To iSuccess
Get ComUpdateInt Of hoJson "invoice_profile.lines[0].type" 5 To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.lines[0].unit_cost.amount" "0" To iSuccess
Get ComUpdateString Of hoJson "invoice_profile.lines[0].unit_cost.code" "CAD" To iSuccess
Get ComUpdateNull Of hoJson "invoice_profile.lines[0].profileid" 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 hoJson to vJson
Get ComPostJson3 Of hoHttp "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" vJson 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 ComStatusCode Of hoResp To iTemp1
Showln iTemp1
Get ComBodyStr Of hoResp To sTemp1
Showln sTemp1
Send Destroy of hoResp
End_Procedure
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": [
]
}
