{"id":1175,"date":"2017-06-02T15:31:16","date_gmt":"2017-06-02T15:31:16","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=1175"},"modified":"2025-03-19T05:24:14","modified_gmt":"2025-03-19T05:24:14","slug":"get-data-from-hubspot-api-with-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/","title":{"rendered":"How to get data from HubSpot API with SSIS"},"content":{"rendered":"

Introduction<\/h2>\n
UPDATE:<\/strong>\u00a0ZappySys has released a brand new API Connector for Hubspot Connector<\/a> which makes it much simpler to\u00a0Read\/Write Hubspot Data in SSIS<\/strong> compared to the steps listed in this article. You can still use steps from this article but if you are new to API or want to avoid learning curve with API then use newer approach.<\/p>\n

Please visit this page to see all<\/a>\u00a0Pre-Configured ready to use API connectors which you can use in SSIS API Source<\/a> \/ SSIS API Destination<\/a> OR\u00a0API ODBC Driver<\/a> (for non-SSIS Apps such as Excel, Power BI, Informatica).<\/p>\n<\/div><\/div>\n

\"\"<\/a>HubSp<\/a>ot<\/a> is a popular platform where CRM, Marketing and Sales meet in one place. It’s a good piece of service, yet sometimes you need to integrate it with your other system.\u00a0In this article you will learn how to pull contacts from\u00a0HubSpot API<\/a> and load them into a SQL Server Database using SSIS and ZappySys SSIS PowerPack<\/a>.<\/p>\n

 <\/p>\n

Prerequisites<\/h2>\n
    \n
  1. HubSpot Account registered (an account you will want to get data from).<\/li>\n
  2. SSIS designer installed.\u00a0Sometimes it is referred as BIDS or SSDT (download it from Microsoft site<\/a>).<\/li>\n
  3. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\n
  4. An existing SQL Server Database and table created (we will use it to load data into).<\/li>\n
  5. ZappySys SSIS PowerPack<\/em> installed.<\/li>\n<\/ol>\n

    Various methods to call HubSpot API<\/h2>\n

    HubSpot API supports two kinds of authentication:<\/p>\n

      \n
    1. OAuth 2.0.<\/li>\n
    2. API Key in URL.<\/li>\n<\/ol>\n

      API Key in URL<\/em>\u00a0is simple, with minimal configuration, but it ought to be used only for development and testing purposes.<\/p>\n

      In this\u00a0tutorial we will show how to authenticate using OAuth 2.0<\/em>, which you should use in your production environment.<\/p>\n

      Step-by-Step \u2013\u00a0<\/span><\/span>Get data from HubSpot API into SQL Server database<\/h2>\n
        \n
      1. Create HubSpot Developer Account (https:\/\/app.hubspot.com\/signup\/developers<\/a>). It’s an account you will need to use to create HubSpot Apps.<\/li>\n
      2. Login with your HubSpot Developer Account (https:\/\/app.hubspot.com\/login<\/a>).<\/li>\n
      3. Select your newly created HubSpot Developer Account:\n
      4. Register HubSpot OAuth App for REST API Call for use with OAuth 2.0 by simply pressing “Create application” button:\n
      5. Name the application (e.g. “ContactsApp”) and choose “Private” to make the application\u00a0hidden from the outer and dangerous world \ud83d\ude42\n
      6. Press “Edit” button on\u00a0the app you just created.<\/li>\n
      7. Write down Client ID<\/em> and Client secret<\/em>. We will need them later for authentication:\n
      8. Open SSIS Designer<\/em> and create a new package.<\/li>\n
      9. Drag a new Data Flow <\/em>task from SSIS Toolbox<\/em> into the\u00a0Control Flow:
        \n<\/em><\/em><\/p>\n
        \"\"

        Dragging and dropping Data Flow Task into Control Flow<\/p><\/div><\/li>\n

      10. Edit Data Flow <\/em>task by double clicking. <\/em>Then drag ZS JSON\u00a0Source<\/em>\u00a0and OLE DB Destination<\/em> components from SSIS Toolbox <\/em>into the\u00a0Data Flow,\u00a0<\/em>but don’t connect them yet:
        \n<\/em><\/em><\/p>\n
      11. Start editing JSON Source<\/em> component:\n
          \n
        1. Set Access Mode<\/em> to File path or web URL<\/em>.<\/li>\n
        2. Set Web URL<\/em> to\u00a0https:\/\/api.hubapi.com\/contacts\/v1\/lists\/all\/contacts\/all?count=100<\/span>.
          \n<\/em><\/em>
          NOTE: We are adding URL parameter with value ?count=100<\/span>, because by default HubSpot API returns 20 contacts and we want to maximize result set and minimize the number of web requests.<\/div><\/div><\/li>\n
        3. Press Select Filter <\/em>and select contacts node or simply enter $.contacts[*]<\/span>\u00a0\u00a0into the text box.<\/em><\/li>\n
        4. Check Use Credentials<\/em> checkbox.<\/li>\n
        5. Select <New ZS-OAUTH Connection><\/em> menu item to create a new\u00a0connection:\n
        6. Configure OAuth 2.0 connection for HubSpot API:\n
            \n
          1. Select HubSpot<\/em> as OAuth Provider<\/em>.<\/li>\n
          2. Select “Use Custom OAuth (App created by you)” option.
            \n
            NOTE: You can also use Default OAuth App option for a quick test. Select it and press “Generate Token<\/em>” button after you enter the scope.<\/div><\/div><\/li>\n
          3. Paste Client Id<\/em>\u00a0and\u00a0Client Secret<\/em>\u00a0you also saved in Step #7.<\/li>\n
          4. Input contacts<\/span>\u00a0as our scope.<\/li>\n
          5. Finally, press “Generate Token”<\/em>\u00a0button:\n
          6. Select your ordinary<\/span> HubSpot account you want to get contacts from:\n
          7. Grant access to your HubSpot App:\n
          8. You will get a prompt to save Access<\/em> and Refresh<\/em> tokens to a backup file. Press “Yes” to save them.
            \n
            NOTE: You will need to pass Refresh Token<\/span>\u00a0as the parameter, when you run the package in another machine. Check Deployment to Production<\/em> section\u00a0for more info.<\/div><\/div><\/li>\n
          9. Configure HubSpot API pagination\n
            \n
              \n
            1. Set Next Link\/Cursor Expression<\/em>\u00a0to $.vid-offset<\/span>\u00a0\u00a0by pressing “…” button or simply pasting the value into the text box.<\/li>\n
            2. In the same way set Stop\u00a0Indicator\/Attribute<\/em> to\u00a0$.has-more<\/span>.<\/li>\n
            3. Input\u00a0false<\/span>\u00a0as Stop indicator value\/Regular expression<\/em>.<\/li>\n
            4. Set Suffix for Next Url<\/em> to &vidOffset=<%nextlink%><\/span>.\n
            5. Press “Preview” button to… well, obviously to preview the results \ud83d\ude42\n
            6. Close “Data Preview” dialog and click “OK” button to save and close JSON Source <\/em>component.<\/li>\n
            7. A\u00a0dialog Metadata Scan Options<\/em>\u00a0should appear, to which you should respond “Ok” \ud83d\ude42<\/li>\n
            8. Now you can connect JSON Source<\/em> component with OLE DB Destination:
              \n<\/em><\/em><\/p>\n
            9. Now modify OLE DB Destination\u00a0<\/em>to have a connection to a SQL Server<\/em> and point to a table, where you want\u00a0contacts to be stored.<\/li>\n
            10. It’s time to map the columns of JSON Source<\/em> with\u00a0destination table columns. With your mouse simply connect corresponding columns or\u00a0simply map Input Column<\/em> with Destination Column<\/em>. Press “OK” to close the window.\n
            11. Finally, funtime! Press “F5” to execute the package. You should see a similar view as below. The number you see is the number of contacts were loaded from HubSpot API to your table:\n
              \"The

              The result of getting HubSpot API data with SSIS<\/p><\/div><\/li>\n<\/ol>\n

              API Rate Limit (Throttling)<\/h2>\n

              HubSpot places limits on using its API<\/a>. Basically, it doesn’t allow you to make endless number of calls per second. Also it has a ceiling for requests made per day. So if you have paging enabled in JSON Source<\/em> component, it will\u00a0make as many requests as it has to retrieve all data. And in this step you may get an error, telling that you exceeded calling rate limit of the API. To avoid that, simply go to the\u00a0Throttling<\/em> tab and set the amount of milliseconds component has to sleep after making each call:<\/p>\n

              \"HubSpot<\/a>

              HubSpot API calls throttling configuration<\/p><\/div>\n

              Making things Dynamic (e.g. URL)<\/span><\/h2>\n

              The URL we used (https:\/\/api.hubapi.com\/contacts\/v1\/lists\/all\/contacts\/all<\/a>)\u00a0in addition to count<\/span>\u00a0parameter, has others as well. Let’s say in some scenarios you want to fetch list memberships \u00a0for contacts, so you must include &showListMemberships=true<\/span>\u00a0 in the URL as well. To make things more generic, instead of using hard-coded true<\/span>\u00a0value, you can use SSIS variables, then the URL will look like this:<\/p>\n

              https:\/\/api.hubapi.com\/contacts\/v1\/lists\/all\/contacts\/all?showListMemberships={{User::ShowMemberships}}<\/pre>\n
              Common\u00a0Errors<\/h2>\n
              For detailed instruction to fix common metadata related errors read this article<\/a>.<\/p>\n
              Truncation related error<\/strong><\/p>\n
              Most common error you may face when you run SSIS Package is truncation error. During design time only 300 rows scanned to detect datatype but at runtime you may extract far more records than 300. So its possible that you will get longer strings than initially expected. If you get error just copy that to notepad and read error carefully. It will explain the steps needed to fix the problem. Basically you can edit Columns on JSON Source UI > Change Data Length or Datatype (if you need more than 4000 chars change to the type to DT_NTEXT and click on Column Name cell to save change). After you edit default settings then make sure to check Lock option (found all on the right side in same row).<\/p>\n
              Authentication related error (happens when you run package from SQL Job Agent)<\/strong><\/p>\n
              So many times when you run from Visual Studio it works fine but when you deploy to Production and run from\u00a0SQL Job it fails. If this is your issue then check you passing Token (i.e. Password Property of HTTP connection) using\u00a0some sort of parameter approach (e.g. from command line or from config file). By default password is encrypted using your account so when you run it from SQL Job it will fail to decrypt it. See more on Package Protection Level<\/a>.<\/p>\n
              <\/a>Deployment to Production<\/h2>\n
              When you are ready to deploy the package to Production\u00a0consider passing Refresh Tokens and other sensitive data as passwords via SSIS parameters. In this way you don\u2019t face authentication related error described in above section.\u00a0See more on Package Protection Level<\/a>.<\/p>\n
              Download Sample Package<\/h2>\n
              Be sure to download a sample SQL Server 2012 SSIS package<\/a>, in case you encounter problems that you can’t go through in the step-by-step part.<\/p>\n
              NOTE: Once you open the package, you won’t be able to run it immediately, but don’t panic. Firstly, it’s because you have a different SQL destination table. Secondly, you won’t see any sensitive data in the package, like tokens. Therefore you will have to perform OAuth authentication process to get those.\u00a0So fix errors one by one and you are good to go. <\/div><\/div>\n
              Conclusion<\/h2>\n
              In this article we\u00a0learned how to call HubSpot API RESTful<\/a> method and retrieve all contacts. Actually, HubSpot API consists of many small APIs and we used Contacts API<\/a>\u00a0method particularly. If you need anything else than simply retrieving the contacts of your account, delve into the vastness of HubSpot API methods<\/a>!<\/p>\n
              Also it’s worth mentioning that JSON Source<\/em> and OAuth Connection <\/em>SSIS components saved us some valuable time, because we avoided using default SSIS\u00a0Script Component<\/em>\u00a0and\u00a0doing all the hard work ourselves.<\/p>\n
              Keywords<\/h2>\n
              How to fetch data from HubSpot API | Pull data from HubSpot API into SQL Server | Call HubSpot API with\u00a0SSIS | Sync HubSpot data to SQL Server | HubSpot\u00a0data integration with SQL Server database | Load data from HubSpot REST API using SSIS<\/p>\n","protected":false},"excerpt":{"rendered":"
              Introduction HubSpot is a popular platform where CRM, Marketing and Sales meet in one place. It’s a good piece of service, yet sometimes you need to integrate it with your other system.\u00a0In this article you will learn how to pull contacts from\u00a0HubSpot API and load them into a SQL Server Database using SSIS and ZappySys […]<\/p>\n","protected":false},"author":1,"featured_media":1862,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225,16,17,8],"tags":[215,206,197,6,199,198,48,148,4],"yoast_head":"\r\nHow to get data from HubSpot API with SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to get data from HubSpot API using SSIS. Read and write data using GET and POST methods. Use OAuth Connection to pull data using RESTful API call.\" \/>\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\/get-data-from-hubspot-api-with-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 get data from HubSpot API with SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to get data from HubSpot API using SSIS. Read and write data using GET and POST methods. Use OAuth Connection to pull data using RESTful API call.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-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=\"2017-06-02T15:31:16+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-03-19T05:24:14+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/hubspot-api-integration-2.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"180\" \/>\r\n\t<meta property=\"og:image:height\" content=\"180\" \/>\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=\"12 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/\",\"name\":\"How to get data from HubSpot API with SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/hubspot-api-integration-2.png\",\"datePublished\":\"2017-06-02T15:31:16+00:00\",\"dateModified\":\"2025-03-19T05:24:14+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to get data from HubSpot API using SSIS. Read and write data using GET and POST methods. Use OAuth Connection to pull data using RESTful API call.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/hubspot-api-integration-2.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/hubspot-api-integration-2.png\",\"width\":180,\"height\":180},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get data from HubSpot API with 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 get data from HubSpot API with SSIS | ZappySys Blog","description":"Learn how to get data from HubSpot API using SSIS. Read and write data using GET and POST methods. Use OAuth Connection to pull data using RESTful API call.","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\/get-data-from-hubspot-api-with-ssis\/","og_locale":"en_US","og_type":"article","og_title":"How to get data from HubSpot API with SSIS | ZappySys Blog","og_description":"Learn how to get data from HubSpot API using SSIS. Read and write data using GET and POST methods. Use OAuth Connection to pull data using RESTful API call.","og_url":"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2017-06-02T15:31:16+00:00","article_modified_time":"2025-03-19T05:24:14+00:00","og_image":[{"width":180,"height":180,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/hubspot-api-integration-2.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":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/","url":"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/","name":"How to get data from HubSpot API with SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/hubspot-api-integration-2.png","datePublished":"2017-06-02T15:31:16+00:00","dateModified":"2025-03-19T05:24:14+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to get data from HubSpot API using SSIS. Read and write data using GET and POST methods. Use OAuth Connection to pull data using RESTful API call.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/hubspot-api-integration-2.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/06\/hubspot-api-integration-2.png","width":180,"height":180},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/get-data-from-hubspot-api-with-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get data from HubSpot API with 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\/1175"}],"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=1175"}],"version-history":[{"count":80,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/1175\/revisions"}],"predecessor-version":[{"id":11242,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/1175\/revisions\/11242"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/1862"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=1175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=1175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=1175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}