Table Contacts
Description
No description available
Supported Operations
Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.| Method | Supported | Reference EndPoint |
|---|---|---|
| SELECT | get_contacts | |
| INSERT | ||
| UPDATE | ||
| UPSERT | ||
| DELETE | ||
| LOOKUP | get_contact |
Examples
SSIS
Use Smartsheet Connector in API Source component to read data or in API Destination component to read/write data:
Read from Contacts table using API Source
API Source - Smartsheet
Read / write SmartSheet data inside your app, perform many SmartSheet operations such as Read, Insert, Update, Delete, List, Search, Export on objects like Sheets, Rows, Users etc without coding with easy to use high performance API Connector
Smartsheet
Contacts
| Optional Parameters | |
|---|---|
| Modified Since | |
Read/write to Contacts table using API Destination
API Destination - Smartsheet
Read / write SmartSheet data inside your app, perform many SmartSheet operations such as Read, Insert, Update, Delete, List, Search, Export on objects like Sheets, Rows, Users etc without coding with easy to use high performance API Connector
Smartsheet
Contacts
Select
| Optional Parameters | |
|---|---|
| Modified Since | |
ODBC application
Use these SQL queries in your ODBC application data source:
Tables - Contacts
SELECT * FROM Contacts --Where Id='abcd1234abc'SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Tables - Contacts
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Contacts --Where Id=''abcd1234abc''';
EXEC (@MyQuery) AT [LS_TO_SMARTSHEET_IN_GATEWAY];