{"id":8965,"date":"2020-08-05T14:08:12","date_gmt":"2020-08-05T14:08:12","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=8965"},"modified":"2025-03-18T13:45:38","modified_gmt":"2025-03-18T13:45:38","slug":"call-onedrive-api-ssis-file-upload-download-delete","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/","title":{"rendered":"How to call OneDrive API in SSIS (Upload, Download)"},"content":{"rendered":"

Introduction<\/h2>\n
UPDATE:<\/strong>\u00a0ZappySys has released a brand new API Connector for OneDrive<\/a> which makes it much simpler to\u00a0Read\/Write OneDrive 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).
\n<\/div><\/div>\n\"\"<\/a>Microsoft Graph API<\/a>\u00a0is a unified way to access many Microsoft services API including OneDrive API<\/strong>. In our previous blog post we saw how to call Office 365 API Graph API<\/a>. In this post, you will focus on how to access OneDrive API in SSIS and use REST API Task or connector like\u00a0SSIS JSON \/ REST API Source Connector<\/a>\u00a0to load Read \/ Download \/ Upload data from OneDrive.<\/p>\n

OneDrive allows to store files on the cloud and and we have seen growing requirements in downloading\/Uploading files from there. This post will provide step by step details of how to Upload\/Download files from OneDrive.<\/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

    Register Microsoft App for OAuth Authentication<\/h2>\n

    In this section, you will learn how to register a custom app in Microsoft Azure portal that will allow access to the OneDrive. So, let’s get started –<\/p>\n

      \n
    1. Log into Microsoft Azure portal<\/a> to register a custom app.<\/li>\n
    2. Register a new application by clicking New Registration link.\n
    3. Provide the name of the custom app and who can access the app in the organization.\n
    4. Go to the App overview and add a Redirect URL.\n
    5. Click on “Add a Platform” under Platform Configuration section and then select “Web” under Web applications section to enter a Redirect URL.\n
      https:\/\/zappysys.com\/oauth<\/pre>\n
      \"Redirect<\/a>
      Redirect URL<\/p><\/div><\/li>\n
    6. Create a Client Secret key which will be used to Authenticate the custom Azure app.\n
    7. Add API Permissions for OneDrive API.\n
    8. Select the following permissions from the Delegated Permissions section.\n
      User.ReadBasic.All\r\nFiles.Read\r\noffline_access<\/pre>\n
      \"Select<\/a>
      Select Delegated Permissions<\/p><\/div><\/li>\n
    9. Take note of Client ID, it will be required while configuring OAuth connection in the SSIS later.\n
      \"Client<\/a>
      Client ID<\/p><\/div><\/li>\n<\/ol>\n
      Get OneDrive File ID<\/h2>\n
      In this section, you will learn how to get the File ID of the CSV file through OneDrive API. So, let’s get started –<\/p>\n
        \n
      1. Go to the\u00a0Microsoft Graph Explorer<\/a>.<\/li>\n
      2. Sign in to Graph Explorer.\n
      3. Run below OneDrive API to get a list of the files from the OneDrive.\n
        https:\/\/graph.microsoft.com\/v1.0\/me\/drive\/root\/children<\/pre>\n
        \"Microsoft<\/a>
        Microsoft Graph Explorer<\/p><\/div>\n
        NOTE:<\/strong>\u00a0Take a note of File ID<\/strong> of the CSV file. For this example, we will download invoices.csv file.<\/div><\/div><\/div>\n<\/li>\n<\/ol>\n
        Create OAuth Connection in SSIS<\/h2>\n
        In this section, you will learn how to create an OAuth connection in SSIS to an Azure custom app. So, let’s get started –<\/p>\n
          \n
        1. Create a new ZS-OAuth connection in SSIS.\n
        2. Configure OAuth connection with following settings.\n
          \n
          <\/div>\n<\/div>\n
          \n\n\n\n\n\n\n\n
          Client ID<\/span><\/td>\nProvide Client ID from App Registration steps<\/span><\/td>\n<\/tr>\n
          Client Secret<\/span><\/td>\nProvide Client Secret from App Registration steps<\/span><\/td>\n<\/tr>\n
          Authorization URL<\/span><\/td>\nhttps:\/\/login.microsoftonline.com\/organizations\/oauth2\/v2.0\/authorize<\/span><\/td>\n<\/tr>\n
          Access Token URL<\/span><\/td>\nhttps:\/\/login.microsoftonline.com\/organizations\/oauth2\/v2.0\/token<\/span><\/td>\n<\/tr>\n
          Scope\/Permissions<\/span><\/td>\nUser.ReadBasic.All<\/span>
          \nFiles.Read.All<\/span>
          \noffline_access<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
          \"OAuth<\/a>
          OAuth Connection Configuration<\/p><\/div><\/li>\n
        3. Go to the Advanced tab and provide Return URL.\n
          https:\/\/zappysys.com\/oauth<\/pre>\n
          \"Add<\/a>
          Add Redirect URL<\/p><\/div><\/li>\n
        4. Click on Generate Token will give a login screen which will allow to generate access and refresh token for the app.<\/li>\n
        5. Approve the requested permissions bu Accepting it.\n
        6. Token has been generate successfully.\n
        7. Let’s test the connection to make sure it is working fine.\n
          \"Connection<\/a>
          Connection Successful<\/p><\/div><\/li>\n<\/ol>\n
          Download CSV File Through OneDrive REST API in SSIS<\/h2>\n
          In this section, you will learn how to download a CSV file through OneDrive API in SSIS and save it into a CSV file.<\/p>\n
            \n
          1. Here is the OneDrive API which allows to read content of the file.\n
            https:\/\/graph.microsoft.com\/v1.0\/me\/drive\/Items\/<File ID>\/content<\/pre>\n<\/li>\n
          2. Replace <File ID> in above step#1 with the file ID that we have got in the\u00a0Get OneDrive File ID<\/strong>\u00a0section.\u00a0Final URL will look something like below.\n
            https:\/\/graph.microsoft.com\/v1.0\/me\/drive\/Items\/01W7L3VCUBS27ILUQKENAK4LQGGTJ2R3TT\/content<\/pre>\n<\/li>\n
          3. Let’s create a SSIS package with Data Flow Task from SSIS Toolbox.\"""\/content<\/pre\"<\/a><\/li>\n
          4. Replace <File ID> in above step#1 with the file ID that we have got in the\u00a0Get OneDrive File ID<\/strong>\u00a0section.\u00a0Final URL will look something like below.\n
            https:\/\/graph.microsoft.com\/v1.0\/me\/drive\/Items\/01W7L3VCWMCGPYZLM2IRAYWROSH4XMQT7A\/content<\/pre>\n<\/li>\n
          5. Configure REST API task as follows.\n
          6. Configure the responses setting as below.\n
          7. Check if the request is made correctly by clicking Test Request\/Response.\n
          8. Let’s have a look at the folder where the file has been downloaded. Here is an example –\n
            \"Downloaded<\/a>
            Downloaded File Example<\/p><\/div><\/li>\n<\/ol>\n
            <\/div>\n
            Download a Text File Through OneDrive API in SSIS<\/h2>\n
            Here is another technique that can be used to download a CSV\/text file through OneDrive API without knowing it’s file ID but file name. Please check this link<\/a> for more details.<\/p>\n
            Download Excel Sheets Through OneDrive API in SSIS<\/h2>\n
            JSON Source also supports reading API response which returns 2D arrays. Such as\u00a0Office Excel Spreadsheet API<\/a>\u00a0to read excel data. Check\u00a0this blog post<\/a>\u00a0to learn a similar scenario to parse 2D arrays. There are few other options for parsing 2D arrays which are\u00a0documented here<\/a>.<\/p>\n
            \n
            \n
            https:\/\/graph.microsoft.com\/v1.0\/me\/drive\/items\/01CYZLFJDYxxxxxxx\/workbook\/worksheets('test')\/range(address='A1:B200')\r\n<\/pre>\n<\/div>\n<\/div>\n
            Upload a File Through OneDrive API in SSIS<\/h2>\n
            In this section, you will learn how to upload a file through OneDrive API in SSIS. Uploading a file has few additional steps and has been documented separately. Please check this link<\/a> for more details.<\/p>\n
            Delete a File Through OneDrive API in SSIS<\/h2>\n
            In this section, you will learn how to delete a file from OneDrive through OneDrive APIs in SSIS.<\/p>\n
              \n
            1. Add a REST API task and configure as follows. Make sure to use the File ID of the file which needs to be deleted from OneDrive. Example URL –\n
              https:\/\/graph.microsoft.com\/v1.0\/me\/drive\/Items\/01W7L3VCSEADQ457W54RBI3I47YGFJOD2I<\/pre>\n
              \"Delete<\/a>
              Delete OneDrive File<\/p><\/div><\/li>\n
            2. Execute the task and you will have file deleted from OneDrive.<\/li>\n<\/ol>\n
              Conclusion<\/span><\/span><\/h2>\n
              In this article, we have learned how to Upload\/Download\/Delete data\/file from OneDrive API in SSIS. We used SSIS REST API Task<\/a> to extract data through OneDrive API in SSIS.\u00a0Download SSIS PowerPack<\/a>\u00a0to try many other automation scenarios not discussed in this article.<\/p>\n","protected":false},"excerpt":{"rendered":"
              Introduction Microsoft Graph API\u00a0is a unified way to access many Microsoft services API including OneDrive API. In our previous blog post we saw how to call Office 365 API Graph API. In this post, you will focus on how to access OneDrive API in SSIS and use REST API Task or connector like\u00a0SSIS JSON \/ […]<\/p>\n","protected":false},"author":9,"featured_media":9115,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[176,205,10],"tags":[228,436,12],"yoast_head":"\r\nHow to call OneDrive API in SSIS (Upload, Download) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to call OneDrive API in SSIS or ODBC Apps (Power BI, Excel, Informatica). Upload \/ Download File to OneDrive, Read \/ Write File.\" \/>\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\/call-onedrive-api-ssis-file-upload-download-delete\/\" \/>\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 OneDrive API in SSIS (Upload, Download) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to call OneDrive API in SSIS or ODBC Apps (Power BI, Excel, Informatica). Upload \/ Download File to OneDrive, Read \/ Write File.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2020-08-05T14:08:12+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-03-18T13:45:38+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/08\/microsoft-onedrive-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"261\" \/>\r\n\t<meta property=\"og:image:height\" content=\"261\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"Ankur Saxena\" \/>\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=\"Ankur Saxena\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/\",\"url\":\"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/\",\"name\":\"How to call OneDrive API in SSIS (Upload, Download) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/08\/microsoft-onedrive-logo.png\",\"datePublished\":\"2020-08-05T14:08:12+00:00\",\"dateModified\":\"2025-03-18T13:45:38+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/5d5e1e28e4e33b9b1476792c1da011b6\"},\"description\":\"Learn how to call OneDrive API in SSIS or ODBC Apps (Power BI, Excel, Informatica). Upload \/ Download File to OneDrive, Read \/ Write File.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/08\/microsoft-onedrive-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/08\/microsoft-onedrive-logo.png\",\"width\":261,\"height\":261,\"caption\":\"Download File from OneDrive in SSIS\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to call OneDrive API in SSIS (Upload, Download)\"}]},{\"@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\/5d5e1e28e4e33b9b1476792c1da011b6\",\"name\":\"Ankur Saxena\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cdb3131deed83646dcf41b48c2b7fe76?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cdb3131deed83646dcf41b48c2b7fe76?s=96&d=mm&r=g\",\"caption\":\"Ankur Saxena\"},\"url\":\"https:\/\/zappysys.com\/blog\/author\/asaxena\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to call OneDrive API in SSIS (Upload, Download) | ZappySys Blog","description":"Learn how to call OneDrive API in SSIS or ODBC Apps (Power BI, Excel, Informatica). Upload \/ Download File to OneDrive, Read \/ Write File.","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\/call-onedrive-api-ssis-file-upload-download-delete\/","og_locale":"en_US","og_type":"article","og_title":"How to call OneDrive API in SSIS (Upload, Download) | ZappySys Blog","og_description":"Learn how to call OneDrive API in SSIS or ODBC Apps (Power BI, Excel, Informatica). Upload \/ Download File to OneDrive, Read \/ Write File.","og_url":"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/","og_site_name":"ZappySys Blog","article_published_time":"2020-08-05T14:08:12+00:00","article_modified_time":"2025-03-18T13:45:38+00:00","og_image":[{"width":261,"height":261,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/08\/microsoft-onedrive-logo.png","type":"image\/png"}],"author":"Ankur Saxena","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ankur Saxena","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/","url":"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/","name":"How to call OneDrive API in SSIS (Upload, Download) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/08\/microsoft-onedrive-logo.png","datePublished":"2020-08-05T14:08:12+00:00","dateModified":"2025-03-18T13:45:38+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/5d5e1e28e4e33b9b1476792c1da011b6"},"description":"Learn how to call OneDrive API in SSIS or ODBC Apps (Power BI, Excel, Informatica). Upload \/ Download File to OneDrive, Read \/ Write File.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/08\/microsoft-onedrive-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/08\/microsoft-onedrive-logo.png","width":261,"height":261,"caption":"Download File from OneDrive in SSIS"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/call-onedrive-api-ssis-file-upload-download-delete\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to call OneDrive API in SSIS (Upload, Download)"}]},{"@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\/5d5e1e28e4e33b9b1476792c1da011b6","name":"Ankur Saxena","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cdb3131deed83646dcf41b48c2b7fe76?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cdb3131deed83646dcf41b48c2b7fe76?s=96&d=mm&r=g","caption":"Ankur Saxena"},"url":"https:\/\/zappysys.com\/blog\/author\/asaxena\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8965"}],"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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=8965"}],"version-history":[{"count":52,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8965\/revisions"}],"predecessor-version":[{"id":11236,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8965\/revisions\/11236"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/9115"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=8965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=8965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=8965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}