SQL Server / New FreshBooks / Create Prepayment Credit
Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
-- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
-- Use this online tool to generate code from sample JSON: Generate Code to Create JSON
-- The following JSON is sent in the request body.
-- {
-- "credit_note": {
-- "credit_number": "0000070",
-- "currency_code": "CAD",
-- "create_date": "2020-07-31",
-- "notes": "Thank you for paying ahead of time",
-- "credit_type": "prepayment",
-- "terms": "Will be applied to future invoice",
-- "lines": [
-- {
-- "name": "Credit",
-- "description": "PrePayment for work",
-- "taxName1": null,
-- "taxAmount1": null,
-- "taxName2": null,
-- "taxAmount2": null,
-- "compounded_tax": false,
-- "qty": 1,
-- "unit_cost": {
-- "amount": "200",
-- "code": "CAD"
-- },
-- "credit_note": null
-- }
-- ],
-- "clientid": 123
-- }
-- }
DECLARE @json int
-- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'credit_note.credit_number', '0000070'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'credit_note.currency_code', 'CAD'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'credit_note.create_date', '2020-07-31'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'credit_note.notes', 'Thank you for paying ahead of time'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'credit_note.credit_type', 'prepayment'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'credit_note.terms', 'Will be applied to future invoice'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'credit_note.lines[0].name', 'Credit'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'credit_note.lines[0].description', 'PrePayment for work'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'credit_note.lines[0].taxName1'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'credit_note.lines[0].taxAmount1'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'credit_note.lines[0].taxName2'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'credit_note.lines[0].taxAmount2'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'credit_note.lines[0].compounded_tax', 0
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'credit_note.lines[0].qty', 1
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'credit_note.lines[0].unit_cost.amount', '200'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'credit_note.lines[0].unit_cost.code', 'CAD'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'credit_note.lines[0].credit_note'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'credit_note.clientid', 123
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Authorization', 'Bearer'
DECLARE @resp int
EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://api.freshbooks.com/accounting/account/E86Qp/credit_notes/credit_notes', 'application/json', @json
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT @iTmp0
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
END
GO
Curl Command
curl -X POST
-H "Authorization: Bearer <access_token>"
-H "Authorization: Bearer "
-d '{
"credit_note": {
"credit_number": "0000070",
"currency_code": "CAD",
"create_date": "2020-07-31",
"notes": "Thank you for paying ahead of time",
"credit_type": "prepayment",
"terms": "Will be applied to future invoice",
"lines": [
{
"name": "Credit",
"description": "PrePayment for work",
"taxName1": null,
"taxAmount1": null,
"taxName2": null,
"taxAmount2": null,
"compounded_tax": false,
"qty": 1,
"unit_cost": {
"amount": "200",
"code": "CAD"
},
"credit_note": null
}
],
"clientid": {{clientId}}
}
}'
https://api.freshbooks.com/accounting/account/E86Qp/credit_notes/credit_notes
Postman Collection Item JSON
{
"name": "Create Prepayment Credit",
"request": {
"method": "POST",
"header": [
{
"key": "Authorization",
"value": "Bearer ",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"credit_note\": {\n \"credit_number\": \"0000070\",\n \"currency_code\": \"CAD\",\n \"create_date\": \"2020-07-31\",\n \"notes\": \"Thank you for paying ahead of time\",\n \"credit_type\": \"prepayment\",\n \"terms\": \"Will be applied to future invoice\",\n \"lines\": [\n {\n \"name\": \"Credit\",\n \"description\": \"PrePayment for work\",\n \"taxName1\": null,\n \"taxAmount1\": null,\n \"taxName2\": null,\n \"taxAmount2\": null,\n \"compounded_tax\": false,\n \"qty\": 1,\n \"unit_cost\": {\n \"amount\": \"200\",\n \"code\": \"CAD\"\n },\n \"credit_note\": null\n }\n ],\n \"clientid\": {{clientId}}\n }\n}",
"options": {
"raw": {
"language": "json"
}
}
},
"url": {
"raw": "https://api.freshbooks.com/accounting/account/E86Qp/credit_notes/credit_notes",
"protocol": "https",
"host": [
"api",
"freshbooks",
"com"
],
"path": [
"accounting",
"account",
"E86Qp",
"credit_notes",
"credit_notes"
]
}
},
"response": [
]
}
