SSIS Components for SuiteCRM

Build 22.0.8509

PDFTemplates

Create, update, delete, and query PDFTemplates table.

Table Specific Information

Select

You can query the PDFTemplates table using any criteria in the WHERE clause. The component will use the SuiteCRM API to filter the results.

SELECT * FROM [PDF Templates] WHERE Active = true

Insert

Create a pdf template by specifying any writable column.

INSERT INTO [PDF Templates] (Active, Name) VALUES (true, 'Test Template')

Update

You can update any pdf template column that is writable, by specifying the Id.

UPDATE [PDF Templates] SET Active = false WHERE Id = '6e1d3749-7e1c-f19c-251d-5b855e30b695'

Delete

Remove a pdf template by specifying the Id.

DELETE FROM [PDF Templates] WHERE Id = '5fddceac-8715-d1f1-efa3-5b854ab921a6'

Columns

Name Type ReadOnly Description
ID [KEY] String False

The unique identifier for the pdf template.

Active Bool False

Whether or not the template is active.

Assigned_to String False

The assignee of the template.

Assigned_User_Id String False

The unique identifier of the assignee.

Body String False

Content of the template's body.

Created_By String False

The Id of the user who created the template.

Created_By2 String False

The name of the user who created the template.

Date_Created Datetime False

Date when the template was created.

Date_Modified Datetime False

Date when the template was modified.

Deleted Bool False

Whether the template was deleted.

Footer String False

The content of the template's footer.

Header String False

The content of the template's header.

Insert_Fields String False

The fields that can be inserted.

Load_Sample String False

The content of the template's sample.

Margin_Bottom Int False

Value of the bottom margin for the template.

Margin_Footer Int False

Value of the margin for the template's footer.

Margin_Header Int False

Value of the margin for the template's header.

Margin_Left Int False

Value of the left margin for the template.

Margin_Right Int False

Value of the right margin for the template.

Margin_Top Int False

Value of the top margin for the template.

Modified_By String False

The Id of the user who modified the template.

Modified_By2 String False

The name of the user who modified the template.

Name String False

The template's name.

Orientation String False

Orientation of the template.

Page_Size String False

The size of the template.

Type String False

The type of the template.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Rows@Next String

Identifier for the next page of results. Do not set this value manually.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509