{"id":8977,"date":"2021-06-04T13:21:26","date_gmt":"2021-06-04T13:21:26","guid":{"rendered":"https:\/\/guide.itscope.com\/?post_type=kb&p=8977"},"modified":"2023-06-28T16:02:56","modified_gmt":"2023-06-28T14:02:56","slug":"exporting-distributor-master-data-via-the-api","status":"publish","type":"kb","link":"https:\/\/guide.itscope.com\/en\/kb\/exporting-distributor-master-data-via-the-api\/","title":{"rendered":"Exporting distributor master data via the API"},"content":{"rendered":"\n

Below you will find all the steps to export supplier master data via API.
<\/p>\n\n\n\n

    \n
  1. Open the ITscope API interface via the following link: https:\/\/api.itscope.com\/api-doc\/2.0\/index.html#!\/<\/a>
    <\/li>\n\n\n\n
  2. Locate the Company\/Distributor option and then select it
    <\/li>\n\n\n\n
  3. You can select your output format under ‘Parameters’. You can currently choose between JSON or XML as the format. For an EXCEL export, select XML
    <\/li>\n\n\n\n
  4. Scroll down and select the ‘Try it out!’ button
    <\/li>\n\n\n\n
  5. You will now be asked to enter your API access details. These can be found in your user profile<\/a><\/li>\n<\/ol>\n\n\n\n
    \"\"<\/a><\/figure>\n\n\n\n

    6. You will now receive another link (Request URL) to retrieve the data:
    https:\/\/api.itscope.com\/2.0\/company\/distributor\/company.xml<\/a>
    <\/p>\n\n\n\n

    7. Copy and paste this link into your browser to get an XML file.<\/p>\n\n\n\n

    You can also use the following link for automation:<\/p>\n\n\n\n

    https:\/\/[customer-number]:[API-Key]@api.itscope.com\/2.0\/company\/distributor\/company.xml<\/p>\n\n\n\n

    Replace the [customer-number] and [API-Key] placeholders with your corresponding details
    <\/p>\n\n\n\n

    8. An XML file with the desired information will open
    <\/p>\n\n\n\n

    9. You can save the page with a right click inside the browser window<\/p>\n\n\n\n

    \"\"<\/a><\/figure>\n\n\n\n

    10. Save the page in a suitable location
    <\/p>\n\n\n\n

    11. The file can then be processed further, e.g. in EXCEL.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Below you will find all the steps to export supplier master data via API. 6. You will now receive another link (Request URL) to retrieve the data:https:\/\/api.itscope.com\/2.0\/company\/distributor\/company.xml 7. Copy and …<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[264],"kbtag":[],"class_list":["post-8977","kb","type-kb","status-publish","hentry","kbtopic-itscope-platform"],"_links":{"self":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/8977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/comments?post=8977"}],"version-history":[{"count":8,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/8977\/revisions"}],"predecessor-version":[{"id":14842,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/8977\/revisions\/14842"}],"wp:attachment":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/media?parent=8977"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtopic?post=8977"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtag?post=8977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}