PDF Generation

You can use the HTML2PDF service to convert dynamically generated HTML into a PDF document. This can be used for generating customer-facing documents like proposals, quotes, invoices, etc.

You access the HTML2PDF service by making an API call as shown below.

Example - Generating a PDF from HTML

Simply call parasql_http() as shown below. Replace YOUR_API_KEY with a key you create via Tools > API Keys.

	CALL parasql_http(
		'POST', 
		'https://www.appsynergy.com/api?action=HTML2PDF&apiKey=YOUR_API_KEY',
		JSON_OBJECT(
			'filename', 'MyInvoice.pdf', 
			'html', Invoice_GetHTML(12345), -- call a function to generate the HTML
			'makePublic', true
		), 
		'MyCallback', -- specify a callback procedure to process the response
		NULL,
		NULL
	);
	

In the above example the HTML is dynamically generated via a stored function called Invoice_GetHTML(); you can see the code here.

If makePublic is true anyone with the document URL can access it.

The Response

Your callback procedure must take the following parameters:

respCode INTEGER, respBody JSON, respHeaders JSON, optMetadata JSON

The respBody will look like this:

	{
	  "status": "OK",
	  "errorMessage": "",
	  "errorCode": "",
	  "data": {
	      "documentField": "HelloWorld.pdf;1048;1598992707098;database/files/a655f610-febd-4f6a-b11d-6bcd696f5456.pdf"
	    }
	}
	

Your callback procedure will need to save the documentField to your database with code something like this:

	INSERT INTO Invoice (Invoice_ID, Invoice_PDF)
	VALUES (parasql_next_val('Invoice'), JSON_VALUE(respBody, '$.data.documentField') );
	