{"id":4464,"date":"2020-10-26T15:44:11","date_gmt":"2020-10-26T15:44:11","guid":{"rendered":"https:\/\/guide.itscope.com\/?post_type=kb&p=4464"},"modified":"2023-06-28T16:00:59","modified_gmt":"2023-06-28T14:00:59","slug":"how-do-i-export-all-master-data-from-a-distributor-via-api","status":"publish","type":"kb","link":"https:\/\/guide.itscope.com\/en\/kb\/how-do-i-export-all-master-data-from-a-distributor-via-api\/","title":{"rendered":"How do I export all master data from a distributor via API?"},"content":{"rendered":"\n

The following steps outline the process of exporting master data from a distributor:<\/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. Find and select the ‘Company\/Distributor’ option<\/li>\n\n\n\n
  3. You can specify your output format under ‘Parameters’. At this point in time, either JSON or XML format can be used. Select the XML format for an EXCEL export<\/li>\n\n\n\n
  4. Scroll down to the ‘Try it out!’ button<\/li>\n\n\n\n
  5. Enter your API access details in the respective dialogue box. You can find your API key in your user profile<\/a><\/li>\n<\/ol>\n\n\n\n
    \"\"<\/a><\/figure>\n\n\n\n

    6. You will then 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 a browser window to obtain an XML file.<\/p>\n\n\n\n

    You can also use the following link to automate this:<\/p>\n\n\n\n

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

    Enter your corresponding data for [customer_number] and [API-Key]<\/p>\n\n\n\n

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

    9. Right clicking in the browser window opens a menu allowing you to save the page<\/p>\n\n\n\n

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

    10. Save the page<\/p>\n\n\n\n

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

    The following steps outline the process of exporting master data from a distributor: 6. You will then receive another link (Request URL) to retrieve the data:https:\/\/api.itscope.com\/2.0\/company\/distributor\/company.xml 7. Copy and paste …<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[263],"kbtag":[],"class_list":["post-4464","kb","type-kb","status-publish","hentry","kbtopic-itscope-export-api-en"],"_links":{"self":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/4464","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=4464"}],"version-history":[{"count":3,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/4464\/revisions"}],"predecessor-version":[{"id":14837,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kb\/4464\/revisions\/14837"}],"wp:attachment":[{"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/media?parent=4464"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtopic?post=4464"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/guide.itscope.com\/en\/wp-json\/wp\/v2\/kbtag?post=4464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}