Endpoint List Contacts

Name

get_contacts

Description

Get a list of contacts. [API reference]

Related Tables

Contacts

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Smartsheet Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Contacts table, therefore it is better to use it, instead of accessing the endpoint directly:

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

API Destination

This Endpoint belongs to the Contacts table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to list contacts:

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];