JDBC Driver for SendGrid

Build 22.0.8462

ImportMarketingContacts

Import contacts to sendgrid account from CSV file.

Stored Procedure Specific Information

The ImportMarketingContacts Stored Procedure requires Field Mapping Ids and path of the File which contains contacts data.

We can Use custom_field ids or reserved_field ids for Field Mapping and We can get these ids using "Get All Field Definitions" endpoint.

NOTE:

1. Email field mapping is mandatory to import contacts from file.

2. As of now only csv file format is supported for this operation.

Example:

EXEC ImportMarketingContacts FileType= 'csv' , FieldMappings= '_rf2_T,_rf9_T' , FilePath='C:\Dev\Tests\v20\ProviderSendgrid\example.csv'

Input

Name Type Required Accepts Input Streams Description
FileType String False False The type of the file

The allowed values are csv.

FieldMappings String True False Comma separated list of field_definition IDs
ListIds String False False Comma separated list of List id's
FilePath String False False The absolute path of the File to import contacts
Content String False True The content as InputStream to be uploaded when FilePath is not specified.

Result Set Columns

Name Type Description
JobId String The Id of the Import Contacts Job

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