Load Data to Excel via the PDM API

Load Data to Excel via the PDM API

Load Data to Excel via the PDM API

You can load PDM API data directly into an Excel file.
  1. Open a new excel workbook and Select the Data tab
  2. Click the From Web option in the Get & Transform Data section
          
      3. From Web dialog box will appear. Select the Advanced radio button
      4. Enter the URL and API token. The parameter name must be exactly "API-Token", then click OK
           
Please refer to the API: Settings article to create the API token.
      5. A new window opens up. Click on the List to view the records
           
      6. Click the To Table icon to convert the group of records into a tabular form
      7. To Table window appers. Choose None and Show as errors from dropdowns and click OK
          
      8. Click the expand columns Icon and unselect Column prefixes. Click OK
           
      9. The Records are now expanded. You can check if the Column Names and Values are correct.
      10. When ready, click the Close & Load button
           
      11. The records will be loaded to the active workbook
           


Related Articles:
  1. API: Settings
  2. API: General Information
  3. API: Use Export Builder Plus (EBP) Profiles


    • Related Articles

    • Data Distribution with PDM

      Data Distribution with PDM To easily get your high-quality product data distributed, you have a variety of options: Channels (controlled by you) Set up exports to happen automatically on your preferred schedule to have data pushed daily, weekly, or ...
    • Website Connector Search API

      How to get started with Search  API? To successfully integrate with Search API, these are the most important things you need to know: Review the Technical Documentation to integrate the API To get started in production, BETA users will need to: ...
    • Backups via Channel Exports

      Backups via Channel Exports PDM backs up your data every day, but it may be convenient to have your own backup copy readily available. This can be accomplished through Channels and Plans. By Making backups of your data, you get fewer chances to get ...
    • Excel Import & Export

      Excel Import & Export If you want to make changes in your data in bulk or add products in bulk, you can use Excel Import & Export. Excel Import Select the required Brand and click on Import/Export. Click Import (If you want to get a PDM template, ...
    • Overwrite/Delete Data with the Excel Import

      If you want to clean out larger portions of your data, Excel Import is an easy approach. When you Export a full Excel file, it will contain all segments as you see them in your account: The Excel Import handles every segment individually when ...