{"id":3359,"date":"2018-05-08T19:26:59","date_gmt":"2018-05-08T19:26:59","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=3359"},"modified":"2018-06-14T13:16:13","modified_gmt":"2018-06-14T13:16:13","slug":"calling-gmail-rest-api-using-ssis-read-emails","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/","title":{"rendered":"Calling Gmail REST API using SSIS &#8211; Read Emails"},"content":{"rendered":"<h2>Introduction to get Gmail with REST API<\/h2>\n<p>In this example, we will show how to <strong>read emails<\/strong> by <strong>calling Gmail REST API using SSIS<\/strong>. To illustrate, we will use <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">ZappySys SSIS PowerPack<\/a>, which includes several tasks to import\/export data from multiples sources to multiple destinations like flat files, Azure, AWS, databases, Office files and more.<\/p>\n<h2>Requirements<\/h2>\n<ol>\n<li>First, you will need <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/download\/\">ZappySys SSIS PowerPack<\/a> installed.<\/li>\n<li>Secondly, you will need SSDT installed.<\/li>\n<\/ol>\n<h2>Getting started<\/h2>\n<h3>How to get information about Gmail with REST API<\/h3>\n<ol>\n<li>First, you will need to create a developer application for Gmail. The following tutorial shows how to create an application for Google Drive, but the steps are similar:\n<ul>\n<li><a href=\"https:\/\/zappysys.com\/blog\/register-google-oauth-application-get-clientid-clientsecret\/\">How to register Google OAuth Application (Get ClientID and ClientSecret)<\/a><\/li>\n<\/ul>\n<\/li>\n<li>Secondly, go to SSDT and create a new SQL Server Integration Project.<\/li>\n<li>Subsequently, drag and drop a Data Flow task and double-click it:\n<div id=\"attachment_3369\" style=\"width: 622px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3369\" class=\"size-full wp-image-3369\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow.png\" alt=\"Using Data flow in SSIS\" width=\"612\" height=\"333\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow.png 612w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow-300x163.png 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><\/a><p id=\"caption-attachment-3369\" class=\"wp-caption-text\">Drag and drop Data Flow<\/p><\/div><\/li>\n<li>Also, in the connection manager create a new ZS-OAuth connection. Select Google as the OAuth provider. In scopes, add the following:\n<pre class=\"lang:default highlight:0 decode:true \">https:\/\/mail.google.com\/<\/pre>\n<p>In addition, press generate token and add your credentials if necessary:<\/p>\n<div id=\"attachment_3382\" style=\"width: 780px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/google-oauth-rest-api-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3382\" class=\"size-full wp-image-3382\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/google-oauth-rest-api-1.png\" alt=\"OAuth credentials\" width=\"770\" height=\"614\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/google-oauth-rest-api-1.png 770w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/google-oauth-rest-api-1-300x239.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/google-oauth-rest-api-1-768x612.png 768w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/a><p id=\"caption-attachment-3382\" class=\"wp-caption-text\">OAuth credentials to connect to Gmail<\/p><\/div>\n<p>&nbsp;<\/li>\n<li>To illustrate, the following example shows how to get the Gmail messages from an account. Check the option use credentials and select the OAuth connection just created. To get your current email messages, you can use the following URL:\n<pre class=\"lang:default highlight:0 decode:true \">https:\/\/www.googleapis.com\/gmail\/v1\/users\/me\/messages\/<\/pre>\n<p>The filter used is the following:<\/p>\n<pre class=\"lang:default decode:true \">$.messages[*].id<\/pre>\n<p>The result displayed shows the ids of the messages. You can see the id of the message in Gmail in the URL when you click a message:<\/p>\n<div id=\"attachment_3373\" style=\"width: 836px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/json-rest-api.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3373\" class=\"size-full wp-image-3373\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/json-rest-api.png\" alt=\"Get Gmail messages with REST API\" width=\"826\" height=\"733\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/json-rest-api.png 826w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/json-rest-api-300x266.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/json-rest-api-768x682.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><p id=\"caption-attachment-3373\" class=\"wp-caption-text\">JSON Source Rest API<\/p><\/div>\n<p>&nbsp;<\/li>\n<li>If you want to check to information of a specific message you can use the following URL.\n<pre class=\"lang:default highlight:0 decode:true \">https:\/\/www.googleapis.com\/gmail\/v1\/users\/me\/messages\/1632106341364d6f<\/pre>\n<p>Where 1632106341364d6f is the message id. The filter used will be the following:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">$.id<\/pre>\n<div id=\"attachment_3374\" style=\"width: 665px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/snippet-info.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3374\" class=\"size-full wp-image-3374\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/snippet-info.png\" alt=\"Data extracted from Gmail\" width=\"655\" height=\"357\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/snippet-info.png 655w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/snippet-info-300x164.png 300w\" sizes=\"(max-width: 655px) 100vw, 655px\" \/><\/a><p id=\"caption-attachment-3374\" class=\"wp-caption-text\">Gmail message information<\/p><\/div>\n<p>The query shows the snippet (body of the message), the history id, size estimated and more.<\/li>\n<li>After this, we can use the following filter:\n<pre class=\"lang:default highlight:0 decode:true \">$.payload.headers[*]<\/pre>\n<p>This will show the sender, the receiver, subject, references, message ID and more information:<\/p>\n<div id=\"attachment_3370\" style=\"width: 516px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/date-information.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3370\" class=\"size-full wp-image-3370\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/date-information.png\" alt=\"To from IP information\" width=\"506\" height=\"356\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/date-information.png 506w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/date-information-300x211.png 300w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/a><p id=\"caption-attachment-3370\" class=\"wp-caption-text\">Information about Gmail<\/p><\/div><\/li>\n<\/ol>\n<h3>How to get label information in Gmail with REST API<\/h3>\n<ol>\n<li>First, you can use the following URL to get the Gmail labels:\n<pre class=\"lang:default highlight:0 decode:true \">https:\/\/www.googleapis.com\/gmail\/v1\/users\/me\/labels\/<\/pre>\n<p>Filter:<\/p>\n<pre class=\"lang:default highlight:0 decode:true \">$.labels[*].id<\/pre>\n<p>&nbsp;<\/li>\n<li>Also, the information displayed is the following:\n<div id=\"attachment_3375\" style=\"width: 689px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/labes-gmail.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3375\" class=\"size-full wp-image-3375\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/labes-gmail.png\" alt=\"Gmail labels\" width=\"679\" height=\"557\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/labes-gmail.png 679w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/labes-gmail-300x246.png 300w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/a><p id=\"caption-attachment-3375\" class=\"wp-caption-text\">Labels in Gmail<\/p><\/div><\/li>\n<li>Finally, the labels are the same than in Gmail:\n<div id=\"attachment_3376\" style=\"width: 204px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/labes-in-gmail-available.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3376\" class=\"size-full wp-image-3376\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/labes-in-gmail-available.png\" alt=\"Gmail labels used\" width=\"194\" height=\"606\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/labes-in-gmail-available.png 194w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/labes-in-gmail-available-96x300.png 96w\" sizes=\"(max-width: 194px) 100vw, 194px\" \/><\/a><p id=\"caption-attachment-3376\" class=\"wp-caption-text\">Gmails labels, categories<\/p><\/div><\/li>\n<\/ol>\n<h3>How to get threads information in Gmail with REST API<\/h3>\n<ol>\n<li>Finally, you can also get the thread information using the following URL:\n<pre class=\"lang:default highlight:0 decode:true \">https:\/\/www.googleapis.com\/gmail\/v1\/users\/me\/threads<\/pre>\n<p>The filter used will be the following:<\/p>\n<pre class=\"lang:default highlight:0 decode:true \">$.threads[*].id<\/pre>\n<p>&nbsp;<\/li>\n<li>The information displayed will be the following:\n<div id=\"attachment_3377\" style=\"width: 836px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/gmail-thread.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3377\" class=\"size-full wp-image-3377\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/gmail-thread.png\" alt=\"Threads in Gmail\" width=\"826\" height=\"733\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/gmail-thread.png 826w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/gmail-thread-300x266.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/gmail-thread-768x682.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><p id=\"caption-attachment-3377\" class=\"wp-caption-text\">Get Threads from Gmail<\/p><\/div><\/li>\n<li>If you press the Preview button, you will see the following information:\n<div id=\"attachment_3378\" style=\"width: 604px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/thread-information-gmail.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3378\" class=\"size-full wp-image-3378\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/thread-information-gmail.png\" alt=\"Gmail information with REST\" width=\"594\" height=\"357\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/thread-information-gmail.png 594w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/thread-information-gmail-300x180.png 300w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/a><p id=\"caption-attachment-3378\" class=\"wp-caption-text\">Thread information using Gmail<\/p><\/div><\/li>\n<\/ol>\n<h3>How to export the data from Gmail to a CSV file<\/h3>\n<ol>\n<li>First, to export the data, we will use the ZS Trash Destination:\n<div id=\"attachment_3380\" style=\"width: 303px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/gmail-to-a-csv-file.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3380\" class=\"size-full wp-image-3380\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/gmail-to-a-csv-file.png\" alt=\"Export data to a file\" width=\"293\" height=\"190\" \/><\/a><p id=\"caption-attachment-3380\" class=\"wp-caption-text\">Export data from Gmail to a CSV file<\/p><\/div><\/li>\n<li>Finally, in the Trash Destination specify the path to store the data from Gmail:\n<div id=\"attachment_3379\" style=\"width: 646px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/csv-configuration-to-store-gmail-information.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3379\" class=\"wp-image-3379 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/csv-configuration-to-store-gmail-information.png\" alt=\"Gmail information stored to get Gmail with REST API\" width=\"636\" height=\"523\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/csv-configuration-to-store-gmail-information.png 636w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/csv-configuration-to-store-gmail-information-300x247.png 300w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/a><p id=\"caption-attachment-3379\" class=\"wp-caption-text\">CSV destination to store Gmail info<\/p><\/div><\/li>\n<\/ol>\n<h2>Conclusion<\/h2>\n<p>To conclude, we can say that <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">ZappySys SSIS PowerPack<\/a>\u00a0is a powerful tool where you can get information from Gmail. This information can be exported to Excel, SQL Server, XML, JSON or any other format using SSIS.\u00a0 <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">Download FREE Trial of SSIS PowerPack<\/a>\u00a0to find out more use cases like this.<\/p>\n<h2>References<\/h2>\n<p>For more information about Gmail, you can refer to these links:<\/p>\n<ul>\n<li><a href=\"https:\/\/developers.google.com\/gmail\/api\/v1\/reference\/\">API Reference<\/a><\/li>\n<li><a href=\"https:\/\/zappysys.com\/blog\/get-data-google-spreadsheet-using-ssis\/\">How to read \/ write Google SpreadSheet using SSIS<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction to get Gmail with REST API In this example, we will show how to read emails by calling Gmail REST API using SSIS. To illustrate, we will use ZappySys SSIS PowerPack, which includes several tasks to import\/export data from multiples sources to multiple destinations like flat files, Azure, AWS, databases, Office files and more. [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":3369,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225,17,8],"tags":[272,306,271],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Calling Gmail REST API using SSIS - Read Emails | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Gmail can be exported to different sources using SSIS and REST API. In this tutorial we will show to get information from Gmail with REST API\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Calling Gmail REST API using SSIS - Read Emails | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Gmail can be exported to different sources using SSIS and REST API. In this tutorial we will show to get information from Gmail with REST API\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2018-05-08T19:26:59+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2018-06-14T13:16:13+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"612\" \/>\r\n\t<meta property=\"og:image:height\" content=\"333\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/\",\"url\":\"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/\",\"name\":\"Calling Gmail REST API using SSIS - Read Emails | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow.png\",\"datePublished\":\"2018-05-08T19:26:59+00:00\",\"dateModified\":\"2018-06-14T13:16:13+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"Gmail can be exported to different sources using SSIS and REST API. In this tutorial we will show to get information from Gmail with REST API\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow.png\",\"width\":612,\"height\":333,\"caption\":\"Drag and drop Data Flow\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calling Gmail REST API using SSIS &#8211; Read Emails\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calling Gmail REST API using SSIS - Read Emails | ZappySys Blog","description":"Gmail can be exported to different sources using SSIS and REST API. In this tutorial we will show to get information from Gmail with REST API","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/","og_locale":"en_US","og_type":"article","og_title":"Calling Gmail REST API using SSIS - Read Emails | ZappySys Blog","og_description":"Gmail can be exported to different sources using SSIS and REST API. In this tutorial we will show to get information from Gmail with REST API","og_url":"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/","og_site_name":"ZappySys Blog","article_published_time":"2018-05-08T19:26:59+00:00","article_modified_time":"2018-06-14T13:16:13+00:00","og_image":[{"width":612,"height":333,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/","url":"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/","name":"Calling Gmail REST API using SSIS - Read Emails | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow.png","datePublished":"2018-05-08T19:26:59+00:00","dateModified":"2018-06-14T13:16:13+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"Gmail can be exported to different sources using SSIS and REST API. In this tutorial we will show to get information from Gmail with REST API","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/05\/data-flow.png","width":612,"height":333,"caption":"Drag and drop Data Flow"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/calling-gmail-rest-api-using-ssis-read-emails\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Calling Gmail REST API using SSIS &#8211; Read Emails"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/3359"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=3359"}],"version-history":[{"count":19,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/3359\/revisions"}],"predecessor-version":[{"id":3448,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/3359\/revisions\/3448"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/3369"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=3359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=3359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=3359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}