Endpoint Download Message Attachments (With search condition)

Name

download_message_attachments

Description

Lists the message attachments for the specified search criterial and user id

Parameters

Output Columns

Input Columns

Examples

SSIS

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

API Source

API Source - Gmail

Read / search Gmail messages, download attachments, send mail and more using Gmail REST API.

Gmail

Download Message Attachments (With search condition)

Required Parameters
SaveFolder	Fill-in the parameter...
Optional Parameters
OverwriteFile	True

API Destination

API Destination - Gmail

Read / search Gmail messages, download attachments, send mail and more using Gmail REST API.

Gmail

Download Message Attachments (With search condition)

Required Parameters
SaveFolder	Fill-in the parameter...
Optional Parameters
OverwriteFile	True

ODBC application

Use these SQL queries in your ODBC application data source:

Download Gmail message attchments to local disk

This example shows how to search messages using search condition and download all message attchments to local disk. File Path is {user_defined_folder} \ {message_id} + {atachment_file_name}

SELECT * 
FROM download_message_attachments
--OR -- just read
--FROM get_message_attachments
WITH(
	  Search='subject:(daily report for July-2024)',
	--Search='after:<<yearstart+1d|~|yyyy/MM/dd,FUN_TO_DATE>> before:<<today-1d|~|yyyy/MM/dd,FUN_TO_DATE>>'	  
	  SaveFolder='c:\temp',
	  OverwriteFile='True'
	  )

Download multiple attchments with search condition (sent after specific date)

This example shows how to download attachments for only those emails sent after specific date

SELECT * 
FROM download_message_attachments
--OR -- just read
--FROM get_message_attachments
WITH(
	  Search='subject:(daily report for July-2024)',
	--Search='has:attachment after:<<monthstart+1d|~|yyyy/MM/dd,FUN_TO_DATE>>'	  
	  SaveFolder='c:\temp',
	  OverwriteFile='True'
	  )

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Download Gmail message attchments to local disk

This example shows how to search messages using search condition and download all message attchments to local disk. File Path is {user_defined_folder} \ {message_id} + {atachment_file_name}

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * 
FROM download_message_attachments
--OR -- just read
--FROM get_message_attachments
WITH(
	  Search=''subject:(daily report for July-2024)'',
	--Search=''after:<<yearstart+1d|~|yyyy/MM/dd,FUN_TO_DATE>> before:<<today-1d|~|yyyy/MM/dd,FUN_TO_DATE>>''	  
	  SaveFolder=''c:\temp'',
	  OverwriteFile=''True''
	  )';

EXEC (@MyQuery) AT [LS_TO_GMAIL_IN_GATEWAY];

Download multiple attchments with search condition (sent after specific date)

This example shows how to download attachments for only those emails sent after specific date

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * 
FROM download_message_attachments
--OR -- just read
--FROM get_message_attachments
WITH(
	  Search=''subject:(daily report for July-2024)'',
	--Search=''has:attachment after:<<monthstart+1d|~|yyyy/MM/dd,FUN_TO_DATE>>''	  
	  SaveFolder=''c:\temp'',
	  OverwriteFile=''True''
	  )';

EXEC (@MyQuery) AT [LS_TO_GMAIL_IN_GATEWAY];