{"id":2241,"date":"2017-11-03T15:25:28","date_gmt":"2017-11-03T15:25:28","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=2241"},"modified":"2025-04-07T13:01:41","modified_gmt":"2025-04-07T13:01:41","slug":"how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/","title":{"rendered":"How to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS)"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>In this blog post you will learn how to call Amazon AWS API using SSIS<\/strong>\u00a0(virtually any API) without a single line of code (No more JAVA, C#, Ruby, Python). Yes you heard it right \ud83d\ude42 . If you are a SSIS \/ ETL Developer or even coder everyone loves drag & drop interface. SSIS has many advantages over other approaches such as Programming SDKs, Command Lines. Main advantage is ease of use, security and long term maintenance without learning expensive coding approach.<\/p>\n

In this post we will use following components to show various possibilities to implement Amazon AWS API integration scenarios inside your ETL workflows.<\/p>\n

\n
\n\n\n\n<\/colgroup>\n\n\n\n\n\n
\"Custom<\/td>\nJSON \/ REST API Source<\/a>\u00a0(REST API, JSON File or OData Service): Use this dataflow component when you have to\u00a0fetch data from REST API webservice like a table<\/strong>. This component allows you to extract JSON data from webservice and de-normalize nested structure so you can save to Relational database such as SQL Server or any other target (Oracle, FlatFile, Excel, MySQL). This component also supports reading local JSON files or direct JSON string (Wildcard pattern supported too e.g. c:\\data\\file*.json).<\/td>\n<\/tr>\n
\"SSIS<\/td>\nWeb API Destination<\/a>\u00a0(POST data to API URL) : Use this dataflow component when you have to call API inside Dataflow (see\u00a0POST to URL<\/a>). Possible Use case: Call Lambda function with various parameters for each input record found in database.<\/td>\n<\/tr>\n
\"Custom<\/td>\nREST API Task<\/a>\u00a0: Use this task when you don\u2019t want to pull REST API data in tabular format but want to call\u00a0rest API for POST data to server, DELETE data from server or things like download HTML page, extract Authentication tokens etc where you not necessarily dealing data in tabular format. This task also allows you many other options such as saving RAW response into variable or file.<\/td>\n<\/tr>\n
\"Custom<\/td>\nXML Source<\/a>\u00a0(SOAP, File, REST) : Use this dataflow component when you have to fetch data from XML or SOAP webservice and consume data like a table. This component allows you to extract data from webservice and save to SQL Server or any other target (Oracle, FlatFile, Excel, MySQL).\u00a0This component also supports reading local XML files or direct XML string.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Prerequisites<\/span><\/h2>\n

Before we do hello world demo for calling Amazon AWS API, you will need to make sure following prerequisites are met.<\/p>\n

    \n
  1. SSIS designer installed.\u00a0Sometimes it is referred as BIDS or SSDT (download it from Microsoft site<\/a>).<\/li>\n
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\n
  3. Access to valid AWS credentials (Access Key, Secret Key for your IAM User). Click here to learn more<\/a> about IAM users and Access Key\/Secret Key<\/li>\n
  4. Make sure SSIS PowerPack<\/em><\/a>\u00a0is installed. Click here to download<\/a>.<\/li>\n<\/ol>\n

    Step-By-Step Example-1 (Call AWS API)<\/h2>\n

    Now lets call some simple GET API call using SSIS REST API Task<\/a>.<\/p>\n

      \n
    1. Install\u00a0 SSIS PowerPack<\/em><\/a>\u00a0(Skip this step if you already installed SSIS PowerPack.<\/li>\n
    2. Open Visual Studio and create new Integration Services Project<\/li>\n
    3. Open SSIS Package and check your SSIS Toolbox you will see many tasks\/components starting with ZS<\/li>\n
    4. From Control flow SSIS Toolbox Drag & drop\u00a0ZS REST API Task<\/a>.<\/li>\n
    5. Double click the REST API task to configure it.<\/li>\n
    6. On REST API Task change URL Access mode drop down to URL from Connection<\/strong><\/li>\n
    7. Now in the connection dropdown click New ZS-OAUTH<\/strong> connection and configure connection as below\n
        \n
      1. Once you see OAuth connection dialog box change Provider Type from Custom to Amazon AWS API<\/strong>\u00a0(v4)<\/li>\n
      2. In the ClientId enter your AWS Access Key<\/strong><\/li>\n
      3. In the ClientSecret enter your AWS Secret Key<\/strong><\/li>\n
      4. Click OK to save connection\n
      5. On REST API Task change few more settings as below\n
          \n
        1. Enter API URL you like to call (In our case we will use\u00a0S3 API (Simple Storage Service)<\/a>. We assume you have ListBucket permission to make this call. If you dont have such permission try to get Full path of File (choose small file) . You have to tweak API url to adjust Service Type, Region,Bucket, Path\n
          https:\/\/s3.us-east-1.amazonaws.com\r\n-- OR -- Use below (list files) if you have single bucket permission---\r\nhttps:\/\/s3.us-east-1.amazonaws.com\/YOUR-BUCKET<\/pre>\n<\/li>\n
        2. Click Test Request. If you have valid Permission and setup looks ok then you will see Response window like below. Using this technique you can call any API to execute AWS operations (E.g. start EC2 VM, Create SQS Queue, Call Lambda Function, Drop or Update resource)\n
          \"Calling<\/a>
          Calling Amazon AWS API Using SSIS REST API Task Example. (Call any AWS API without SDK. such as EC2 API, SQS API, Lambda API, Redshift API, DynamoDB API)<\/p><\/div><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
          Step-By-Step Example-2 (Loading data from AWS API to SQL Server)<\/h2>\n
          Now lets do more interesting scenario. We will call AWS S3 API to get S3 File list from Bucket. After extract we will save that list to SQL Server Table. Since Amazon S3 API is XML based API we will use ZappySys SSIS XML Source<\/a>. For JSON based API use JSON Source instead. XML Source \/ JSON Source both can parse API response into Rows and Columns so you can easily store it into SQL Server. Now lets see how to do this.<\/p>\n
            \n
          1. From Control flow SSIS Toolbox Drag & drop Data Flow Task<\/li>\n
          2. Double click Data Flow Task. From SSIS Toolbox Drag & drop\u00a0ZS SSIS XML Source<\/a>.<\/li>\n
          3. Double click the XML Source to configure it.<\/li>\n
          4. In the URL text box enter API URL like below to list S3 Files for specified bucket (Change YOUR-BUCKET to your own name)\n
            https:\/\/s3.us-east-1.amazonaws.com\/YOUR-BUCKET<\/pre>\n<\/li>\n
          5. Now check Use Credentials and Select same Amazon API connection we created in previous example.<\/li>\n
          6. Click on Select Filter (This step allows us to flatten the XML hierarchy. Select the node which is Array icon like below. If prompted to treat selected node as array click Yes.\n
          7. Click Preview to see your data. Click OK to save.\n
          8. Now attach your XML source to target like OLEDB Destination to load data to SQL Server or other Target (e.g. Oracle, MySQL)<\/li>\n
          9. Execute SSIS Package to load data from Amazon AWS API to SQL Server.\n
            \"SSIS<\/a>
            SSIS Package – Read Amazon S3 File List and load into SQL Server Table (Call AWS API Example)<\/p><\/div><\/li>\n<\/ol>\n
            <\/h2>\n
            File Upload Example – Low level API – Call PUT request<\/span><\/h2>\n
            There will be a time when you want to take total control of your AWS API calls. One example is if you wish to Upload \/ Write\u00a0data to S3 then components like ZappySys Amazon S3 CSV Destination or Amazon Storage Task might need additional permission such as HeadObject<\/a>\u00a0. If you have only write permission on bucket then this will fail to execute Task. In such case you can use REST API Task like below way.<\/p>\n
            Basically we exported data from Relation Database to CSV File using Export CSV File Task<\/a>\u00a0and then we uploaded file content using REST API Task.<\/p>\n
            Upload Text File to S3 (i.e. JSON, CSV, XML …)<\/h3>\n
            Your URL Format can be like this. Region codes can be found here<\/a><\/p>\n
            https:\/\/YOUR-BUCKET.s3.YOUR-REGION.amazonaws.com\/YOUR-FILE\r\nhttps:\/\/YOUR-BUCKET.s3.YOUR-REGION.amazonaws.com\/SOME-FOLDER\/SOME-SUB-FOLDER\/YOUR-FILE<\/pre>\n
             <\/p>\n
            \"Upload<\/a>
            Upload file to Amazon S3 – Call low level API (PUT request)<\/p><\/div>\n
             <\/p>\n
            Upload Binary File to S3 (i.e. Zip, mp3, gzip, png, jpeg…)<\/h3>\n
            Above method only works for Text Files. If you have Binary files (e.g. Zip file, mp3, png, jpeg) then you can use below workaround.<\/p>\n
              \n
            1. Check Is Multi Part \/ File Upload Option next to the Body editor (Read this Post for more info<\/a>)<\/li>\n
            2. In the Body enter file path like below\n
              @c:\\folder\\some-file.xyz<\/pre>\n<\/li>\n
            3. That’s it, now your binary file can be uploaded to S3 same way as Text file we uploaded in earlier section.<\/li>\n<\/ol>\n
               <\/p>\n
              NOTE:<\/strong> Binary file option only works in the latest Build Uploaded after 5\/21\/2020<\/span><\/p>\n
               <\/p>\n
              Debugging AWS API Command Line Requests using Fiddler (Web Proxy)<\/span><\/h2>\n
              Before we see more examples of calling AWS API lets first learn how to capture Request data using aws command line<\/a>\u00a0(CLI). We will use Fiddler<\/a> to capture AWS API\u00a0Requests.<\/p>\n
                \n
              1. Download and Install Fiddler<\/a> (Free Tool)<\/li>\n
              2. Install \u00a0aws command line<\/a><\/li>\n
              3. Open command prompt and type aws configure command to set credentials.\u00a0 For more info\u00a0see configure aws credentials<\/a> .. see below example.\n
                c:> aws configure\r\nAWS Access Key ID [None]: AKIAIOSFODNN7EXAMPLE\r\nAWS Secret Access Key [None]: wJalrXUtnFEMI\/K7MDENG\/bPxRfiCYEXAMPLEKEY\r\nDefault region name [None]: us-west-2\r\nDefault output format [None]: json<\/pre>\n<\/li>\n
              4. Once you set credentials launch Fiddler<\/li>\n
              5. On the Fiddler Tools menu > Click Fiddler Option > HTTPS > Check Decrypt HTTPS Traffic<\/strong><\/li>\n
              6. Once you do that you may be asked to Trust Fiddler Certificate click OK<\/li>\n
              7. Close and Open Fiddler to apply setting<\/li>\n
              8. Now any command you type in aws command line will show up in fiddler. This command we can use in SSIS REST API Task or XML Source to call virtually Any API AWS supports.<\/li>\n
              9. For example to call some lambda function (supply input json data from file) use below command and watch Fiddler Trace. Notice we added\u00a0–no-verify-ssl<\/strong> option so we can see requests in custom web proxy like fiddler (This option will trust Fiddler certificate).\n
                c:\\>aws lambda invoke --function-name HelloWorld c:\\temp\\outputfile.txt --no-verify-ssl --payload file:\/\/c:\/\/test\/customer.json<\/pre>\n
                 <\/p>\n
                \"Capture<\/a>
                Capture AWS Commandline (CLI) request using Fiddler<\/p><\/div><\/li>\n
              10. Once you have this information you can use it inside ZappySys Components which supports API calls (e.g. REST API Task, JSON Source, XML Source). For this example we will use REST API Task to call same Lambda Function. Things to change to call any API is URL, Method, ContentType, Body. If its GET call then you wont have Body.\n
              11. That’s it.. You can now take this same concept and call virtually API AWS API right insight SSIS without any SDK or command line tools.<\/li>\n<\/ol>\n
                Call API Gateway Endpoint (Default URL)<\/h2>\n
                If you wish to call API hosted on Amazon API Gateway Service then enter direct URL. You have to use OAuth Connection (AWS v4 Provider) as previous section.<\/p>\n
                Typical URL may look like as below if you calling API gateway Endpoint.<\/p>\n
                https:\/\/c5hhigf5mh.execute-api.us-east-1.amazonaws.com\/prod\/pets<\/pre>\n
                Call AWS API with Region and Custom Service Name<\/h2>\n
                There will be a time when you will have to call AWS API URL and it doesnt indicate Region \/ Service but you have to supply part of signature for Authentication.\u00a0 In this case just enter AWS Service and Region along with ClientID, Secret Fields (Custom Service and\u00a0 Region attributes were introduced in v3.0 or higher so if you are not seeing on OAuth Connection UI then you probably running older version).<\/p>\n
                 <\/p>\n
                Call Amazon Athena API<\/h2>\n
                Check this article<\/a> for detailed instructions<\/p>\n
                Call AWS EC2 API<\/span><\/h2>\n
                Here is an example of calling EC2 API. This is example of listing EC2 instances.<\/p>\n
                Request:<\/p>\n
                POST https:\/\/ec2.us-east-1.amazonaws.com\/\r\nContent-Type: application\/x-www-form-urlencoded; charset=utf-8\r\n\r\nAction=DescribeInstances&Version=2016-11-15<\/pre>\n
                Call\u00a0AWS\u00a0<\/span>Lambda API<\/h2>\n
                Here is some example of calling Lambda function<\/p>\n
                Request:<\/p>\n
                POST https:\/\/lambda.YOUR-REGION.amazonaws.com\/2015-03-31\/functions\/YOUR-FUNCTION\/invocations\r\n\r\n{you-json-input-goes-in-body}\r\n<\/pre>\n
                <\/h2>\n
                Call AWS ElasticSearch<\/h2>\n
                If you are using AWS Hosted Managed ElasticSearch<\/a>\u00a0then also you can use OAuth AWS v4 Provider as below. Assuming you have configured correct Policy<\/a> to allow your IAM User Account \/ IP address.<\/p>\n
                \"Call<\/a>
                Call AWS Hosted ElasticSearch REST API in SSIS (V4 Request Signing)<\/p><\/div>\n
                Call\u00a0AWS\u00a0<\/span>API using Native Task\/Components<\/h2>\n
                ZappySys provides many High quality Tasks \/ Components for AWS integration. See below list.<\/p>\n\n\n\n\n\n\n
                Amazon AWS Cloud Integration<\/strong><\/th>\n<\/tr>\n
                \"Custom\u00a0Amazon S3 Task<\/a><\/td>\n\"Custom\u00a0Amazon Redshift Data Transfer Task<\/a><\/td>\n\"Custom\u00a0Amazon Redshift ExecuteSql Task<\/a><\/td>\n<\/tr>\n
                \"Custom\u00a0Amazon Redshift Cluster Management Task<\/a><\/td>\n\"Custom\u00a0Amazon DynamoDB Source<\/a><\/td>\n\"Custom\u00a0Amazon DynamoDB Destination<\/a><\/td>\n<\/tr>\n
                \"Custom\u00a0Amazon Redshift Source<\/a><\/td>\n\"Custom\u00a0Amazon SQS Queue Source<\/td>\n\u00a0\"Custom\u00a0Amazon SQS Queue Destination<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                Conclusion<\/h2>\n
                Amazon AWS Cloud integration from SSIS packages becoming more and more common scenario. ZappySys provides easy to use no coding connectors to achieve\u00a0many time consuming scenarios. Having clean drag and drop approach\u00a0is not only faster but more secure using inbuilt SSIS framework. Try SSIS PowerPack<\/a> to explore many other scenarios not discussed in this article.<\/p>\n","protected":false},"excerpt":{"rendered":"
                Introduction In this blog post you will learn how to call Amazon AWS API using SSIS\u00a0(virtually any API) without a single line of code (No more JAVA, C#, Ruby, Python). Yes you heard it right \ud83d\ude42 . If you are a SSIS \/ ETL Developer or even coder everyone loves drag & drop interface. SSIS […]<\/p>\n","protected":false},"author":1,"featured_media":2317,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43,225,99,204,17,205,10,62],"tags":[29,256,172,123,255,60,35,257,12,4],"yoast_head":"\r\nHow to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to call Amazon AWS API using SSIS without any SDK or command line tools. Execute Lambda function, call API for EC2 , S3, SQS, Redshift, DynamoDB..\" \/>\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\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to call Amazon AWS API using SSIS without any SDK or command line tools. Execute Lambda function, call API for EC2 , S3, SQS, Redshift, DynamoDB..\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2017-11-03T15:25:28+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-04-07T13:01:41+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/11\/amazon-web-services-logo.jpg\" \/>\r\n\t<meta property=\"og:image:width\" content=\"800\" \/>\r\n\t<meta property=\"og:image:height\" content=\"450\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/\",\"url\":\"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/\",\"name\":\"How to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/11\/amazon-web-services-logo.jpg\",\"datePublished\":\"2017-11-03T15:25:28+00:00\",\"dateModified\":\"2025-04-07T13:01:41+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to call Amazon AWS API using SSIS without any SDK or command line tools. Execute Lambda function, call API for EC2 , S3, SQS, Redshift, DynamoDB..\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/11\/amazon-web-services-logo.jpg\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/11\/amazon-web-services-logo.jpg\",\"width\":800,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS)\"}]},{\"@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\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS) | ZappySys Blog","description":"Learn how to call Amazon AWS API using SSIS without any SDK or command line tools. Execute Lambda function, call API for EC2 , S3, SQS, Redshift, DynamoDB..","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\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/","og_locale":"en_US","og_type":"article","og_title":"How to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS) | ZappySys Blog","og_description":"Learn how to call Amazon AWS API using SSIS without any SDK or command line tools. Execute Lambda function, call API for EC2 , S3, SQS, Redshift, DynamoDB..","og_url":"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2017-11-03T15:25:28+00:00","article_modified_time":"2025-04-07T13:01:41+00:00","og_image":[{"width":800,"height":450,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/11\/amazon-web-services-logo.jpg","type":"image\/jpeg"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/","url":"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/","name":"How to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/11\/amazon-web-services-logo.jpg","datePublished":"2017-11-03T15:25:28+00:00","dateModified":"2025-04-07T13:01:41+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to call Amazon AWS API using SSIS without any SDK or command line tools. Execute Lambda function, call API for EC2 , S3, SQS, Redshift, DynamoDB..","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/11\/amazon-web-services-logo.jpg","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/11\/amazon-web-services-logo.jpg","width":800,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS)"}]},{"@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\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2241"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=2241"}],"version-history":[{"count":16,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2241\/revisions"}],"predecessor-version":[{"id":11341,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2241\/revisions\/11341"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/2317"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=2241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=2241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=2241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}