{"id":9507,"date":"2022-01-20T19:07:09","date_gmt":"2022-01-20T19:07:09","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=9507"},"modified":"2024-06-30T19:10:21","modified_gmt":"2024-06-30T19:10:21","slug":"query-salesforce-data-using-bulk-api-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/","title":{"rendered":"How to query salesforce data using Bulk API in SSIS"},"content":{"rendered":"

Introduction<\/h2>\n

In our previous post, we saw how to read Salesforce<\/a> data using SSIS Salesforce Source (Which uses SOAP API under the hood). This may be slow if you have millions of rows because Salesforce Source paginates every 2000 rows, so it’s not a good option to read millions of rows to iterate on a large Salesforce dataset (Table or Query). To increase the read speed, you can use BULK API. This article explains how to read salesforce data using BULK API and increase read speed.<\/p>\n

Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, you will need to make sure the following prerequisites are met:\r\n
    \r\n \t
  1. SSIS<\/abbr> designer installed.\u00a0Sometimes it is referred to as BIDS<\/abbr> or SSDT<\/abbr> (download it from the Microsoft site<\/a>).<\/li>\r\n \t
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
  3. Make sure\u00a0ZappySys SSIS PowerPack<\/a><\/span>\u00a0is installed (download it<\/a>, if you haven't already).<\/li>\r\n \t
  4. (Optional step<\/em>).<\/em>\u00a0Read this article<\/a>, if you are planning to deploy packages to a server and schedule their execution later.<\/li>\r\n<\/ol><\/div>\n

    NEW Version (v5.5+)<\/h2>\n

    In the new version (v5.5), we have added an option to query in Bulk Mode. This means if you have millions of Salesforce object rows to read, no worries; it may be very fast in the new version. Previously, it used to take a long time because it read in batches of 2000 rows in each request. With the Bulk API, the batch size is really large.<\/p>\n

    Here is how to set Salesforce Bulk API Mode in SELECT query (Read operation).<\/p>\n

      \n
    1. Install new version of SSIS PowerPack. Make sure it is v5.5 or higher.<\/li>\n
    2. Open existing Salesforce Source UI<\/li>\n
    3. Make sure you check [Use Bulk API]<\/strong> option like below. if you do not see this option then most likely you are using older version.
      \n-OR-
      \nJust add #bulkmode<\/strong> prefix in the SQL query like below, it will use Bulk API<\/p>\n
      \"\"<\/a>

      Bulk API mode for SSIS Salesforce Source (Read Large amount of data using SOQL Query)<\/p><\/div><\/li>\n<\/ol>\n

      OLD Version<\/h2>\n

      If you are using an older version of SSIS Power Pack (v5.4.0 or older), you can follow the steps mentioned in the following section.<\/p>\n

      We will see how to query using Salesforce Bulk API in SSIS. It involves three simple steps like the one below.<\/p>\n

        \n
      1. Call BULK API – Submit SOQL Query and receive a JobId back (Use SSIS Salesforce API Task<\/a>)\n
        https:\/\/{your-instance}.salesforce.com\/services\/data\/v50.0\/jobs\/query<\/pre>\n<\/li>\n
      2. Keep checking Job Status Until Status is JobComplete<\/strong> (Use SSIS Salesforce API Task<\/a>)\n
        https:\/\/{your-instance}.salesforce.com\/services\/data\/v50.0\/jobs\/query\/{{User::JobId}}<\/pre>\n<\/li>\n
      3. Read Query Result\u00a0 (Use SSIS CSV Source<\/a>)\n
        https:\/\/{your-instance}.salesforce.com\/services\/data\/v50.0\/jobs\/query\/{{User::JobId}}\/results<\/pre>\n<\/li>\n<\/ol>\n
        \"Query<\/a>
        Query Salesforce Data using Bulk API in SSIS (read using SOQL query in Bulk mode \/ large dataset)<\/p><\/div>\n
        Now, let’s look at everything in detail.<\/p>\n
        Obtain Salesforce Credentials<\/h3>\n
        The first step to call Salesforce API is to obtain credentials (security token or OAuth ClientId \/Secret)<\/p>\n
        Method#1 – Check this article<\/a> to use UserId\/ Password \/ SecretToken<\/strong>
        \nMethod#2 – Check         this article<\/a> to use the OAuth<\/strong> Connection Option<\/p>\n
        Create Salesforce Connection<\/h3>\n
        Once we have Salesforce Credentials, we can create a new Salesforce Connection (You can do this from Task UI or the below way)<\/p>\n
          \n
        1. Open Visual Studio ( Assuming you already have SSIS installed along with\u00a0ZappySys PowerPack<\/a>\u00a0)<\/li>\n
        2. Create a New SSIS Package Project.<\/li>\n
        3. Right-click on the Connection Manager panel and click on New Connection.
          \n\"SSIS<\/li>\n
        4. Select ZS-SALESFORCE<\/strong> Connection Manager from the Connection Managers list and Click on the Add Button.
          \n\"SSIS<\/li>\n
        5. Now in Connection Manager UI, Enter your SalesForce Credentials (OAuth Client Id\/. Secret –or— User Name, Password and Security Token), and leave all other properties as it is.
          \n\"SSIS<\/li>\n<\/ol>\n
          Call Create Job – Retrieve \/ Save JobId<\/h3>\n
          Once the connection is created, we can create our first step. Basically, we will call this API to create Job<\/a> (Bulk Read)<\/p>\n
            \n
          1. Here, in Visual Studio, drag and drop the ZS Salesforce API Task on the design surface.\"SSIS<\/li>\n
          2. Double click the Task and configure Request Settings Tab like below
            \n– Select Salesforce Connection (Created in the previous section)
            \n– Check Use direct URL<\/strong>
            \n– Enter URL like below (Replace {your-instance}<\/strong> with your own instance (i.e. na9) . For more information on how to find out my
            \nsalesforce instance id\u00a0            check this article<\/a><\/p>\n
            https:\/\/{your-instance}.salesforce.com\/services\/data\/v50.0\/jobs\/query\r\n<\/pre>\n
            – Request Method POST<\/strong>
            \n– Enter Body like below (You can use your own             SOQL query<\/a>). Keep in mind SQOL must be encoded for JSON format<\/a>. This means the entire SQL must be in one line (replace new lines with \\r\\n , quotes with \\” and tabs with \\t)
            \nFor example, to execute SELECT Id, Name FROM Accounts, you can write something like the one below in BODY.<\/p>\n
            {\r\n  \"operation\": \"query\",\r\n  \"query\": \"SELECT Id, Name\\r\\nFROM Account\"\r\n}<\/pre>\n
            The above is for below (with a new line)<\/p>\n
            SELECT Id, Name\r\nFROM Account<\/pre>\n
            \"Create<\/a>
            Create Job – Call Bulk API to Read \/ Query using SOQL<\/p><\/div><\/li>\n
          3. Now Click Test Request (Copy the JobId<\/strong> which we will use in the Variable for Designtime Testing)<\/li>\n
          4. On the Response Tab, configure it like the below.
            \n– Select Response content Type = Json
            \n– Enter $.id<\/strong> as the expression
            \n– Check Save response option
            \n– Select Save to Variable and click New to create a variable. Name it JobId<\/strong> and enter a sample JobId<\/strong> value (copied from the previous step)<\/p>\n
            \"Extract<\/a>
            Extract Salesforce JobId save to SSIS Variable<\/p><\/div><\/li>\n<\/ol>\n
            Do Status Check – Look for JobComplete<\/h3>\n
            Once we create a job and store JobId in the variable we have to keep checking Job status<\/a> every X seconds. Don’t worry you don’t have to use Loop or timer control for that. ZappySys made it so simple to check such thing without Loop \/Timer.<\/p>\n
              \n
            1. Drag and drop the ZS Salesforce API Task in the design surface.\"SSIS<\/li>\n
            2. Double click and configure like below. URL will be different this time. Use variable as below and replace your instance ID\n
              https:\/\/{your-instance}.salesforce.com\/services\/data\/v50.0\/jobs\/query\/{{User::JobId}}<\/pre>\n
              \"Check<\/a>
              Check Salesforce Job Status Periodically (Without Loop + Timer Controls)<\/p><\/div><\/li>\n
            3. Now go to the Status Check Tab and configure it, as shown below. It will keep looking for the words below in the response to decide whether it is a Success or Failure. If those words are not found, they will be checked every 5 seconds (Maximum 1200 secs).
              \n– Check Enable Status Check option
              \n– For Success Value – Enter JobComplete<\/strong>
              \n-Check Fail task option
              \n– Enter Cancel|Failed|Abort<\/strong> in the text box<\/p>\n
              \"Configure<\/a>
              Configure Job Status Check Loop using Salesforce API Task<\/p><\/div><\/li>\n<\/ol>\n
              <\/h2>\n
              Read data (Compressed CSV Format)<\/h3>\n
              Last step is read the result<\/a> from completed Salesforce Job. Its in CSV format so we will use Advanced\u00a0SSIS CSV Source<\/a> which supports API connection to Salesforce. For that, we will use the same Salesforce API Task used before.<\/p>\n
                \n
              1. Drag and Drop SSIS Data Flow Task from SSIS Toolbox.
                \n\"SSIS<\/li>\n
              2. Double click on the DataFlow task to see DataFlow designer surface.<\/li>\n
              3. Here, In Visual Studio, drag and drop the ZS CSV Source (Web API or File) in the design panel
                \n\"SSIS<\/li>\n
              4. Double click on ZS CSV Source (Web API or File) Configure it like below.
                \n– Enter URL to read result like this (You can supply OPTIONAL\u00a0maxRecords parameters to control how much data comes in a single response)<\/p>\n
                https:\/\/{your-instance}.salesforce.com\/services\/data\/v50.0\/jobs\/query\/{{User::JobId}}\/results\r\n--OR--\r\nhttps:\/\/{your-instance}.salesforce.com\/services\/data\/v50.0\/jobs\/query\/{{User::JobId}}\/results?maxRecords=50000<\/pre>\n
                – Check Use Credentials and select Salesforce Connection
                \n– Click Preview (assuming JobId variable has a valid completed JobId)<\/p>\n
                \"Read<\/a>
                Read Salesforce Bulk API Job Result – Using SSIS CSV \/ API Source<\/p><\/div><\/li>\n
              5. Now, set up Pagination as below to read all records using an automated loop. You will need VERSION Released after Jun 20, 2022<\/strong> to use Regular Expression feature in Header Value extractionBy default, Salesforce doesn’t send all records in response so we need to setup pagination<\/a>. In below example we are reading Sforce-Locator<\/strong> attribute from Response and sending it to the next URL as locator=<continue-token><\/strong> value
                \n– Choose Response Header Contains Continue Token\u00a0<\/strong>
                \n– Enter below expression in Page Num Indicator<\/strong><\/p>\n
                locator=Sforce-Locator(^((?!null\\b).)*$)<\/pre>\n
                Basically, the above expression will keep looping until we find Sforce-Locator : null<\/strong> in the response header.<\/p>\n
                \"Pagination<\/a>
                Pagination for Salesforce Bulk Query API (Get Header Value from Sforce-Locator)<\/p><\/div><\/li>\n
              6. Click OK to save and now run entire package like below.<\/li>\n<\/ol>\n
                \"Query<\/a>
                Query Salesforce Data using Bulk API in SSIS (read using SOQL query in Bulk mode \/ large dataset)<\/p><\/div>\n
                Conclusion<\/h2>\n
                In this article we saw how to use various ZappySys Components \/ Task to achieve complex Salesforce API calls to read Query data using Bulk API. Download SSIS PowerPack<\/a>\u00a0and try yourself and also explore 70+ other tasks \/components not discussed in this article.<\/p>\n","protected":false},"excerpt":{"rendered":"
                Introduction In our previous post, we saw how to read Salesforce data using SSIS Salesforce Source (Which uses SOAP API under the hood). This may be slow if you have millions of rows because Salesforce Source paginates every 2000 rows, so it’s not a good option to read millions of rows to iterate on a […]<\/p>\n","protected":false},"author":1,"featured_media":11114,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[447,209,466],"tags":[591,160,161,95,210],"yoast_head":"\r\nHow to query salesforce data using Bulk API in SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"How to query salesforce data using Bulk API in SSIS - ZappySys Blog\" \/>\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\/query-salesforce-data-using-bulk-api-ssis\/\" \/>\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 query salesforce data using Bulk API in SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"How to query salesforce data using Bulk API in SSIS - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/\" \/>\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=\"2022-01-20T19:07:09+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2024-06-30T19:10:21+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2022\/01\/ssis-salesforce-bulk-api-option-soql-select-query.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"677\" \/>\r\n\t<meta property=\"og:image:height\" content=\"585\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"10 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/\",\"name\":\"How to query salesforce data using Bulk API in SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2022\/01\/ssis-salesforce-bulk-api-option-soql-select-query.png\",\"datePublished\":\"2022-01-20T19:07:09+00:00\",\"dateModified\":\"2024-06-30T19:10:21+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"How to query salesforce data using Bulk API in SSIS - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2022\/01\/ssis-salesforce-bulk-api-option-soql-select-query.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2022\/01\/ssis-salesforce-bulk-api-option-soql-select-query.png\",\"width\":677,\"height\":585,\"caption\":\"Bulk API mode for SSIS Salesforce Source (Read Large amount of data using SOQL Query)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to query salesforce data using Bulk API in SSIS\"}]},{\"@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 query salesforce data using Bulk API in SSIS | ZappySys Blog","description":"How to query salesforce data using Bulk API in SSIS - ZappySys Blog","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\/query-salesforce-data-using-bulk-api-ssis\/","og_locale":"en_US","og_type":"article","og_title":"How to query salesforce data using Bulk API in SSIS | ZappySys Blog","og_description":"How to query salesforce data using Bulk API in SSIS - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2022-01-20T19:07:09+00:00","article_modified_time":"2024-06-30T19:10:21+00:00","og_image":[{"width":677,"height":585,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2022\/01\/ssis-salesforce-bulk-api-option-soql-select-query.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/","url":"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/","name":"How to query salesforce data using Bulk API in SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2022\/01\/ssis-salesforce-bulk-api-option-soql-select-query.png","datePublished":"2022-01-20T19:07:09+00:00","dateModified":"2024-06-30T19:10:21+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"How to query salesforce data using Bulk API in SSIS - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2022\/01\/ssis-salesforce-bulk-api-option-soql-select-query.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2022\/01\/ssis-salesforce-bulk-api-option-soql-select-query.png","width":677,"height":585,"caption":"Bulk API mode for SSIS Salesforce Source (Read Large amount of data using SOQL Query)"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/query-salesforce-data-using-bulk-api-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to query salesforce data using Bulk API in SSIS"}]},{"@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\/9507"}],"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=9507"}],"version-history":[{"count":9,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9507\/revisions"}],"predecessor-version":[{"id":11116,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9507\/revisions\/11116"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11114"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=9507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=9507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=9507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}