Exporting Data: Examples

Different approaches for exporting data from different services

Overview

In this section, examples are provided of how to proceed when you want to export data from SAP Asset Intelligence Network tenant. The strategies for obtaining all the required data from service to service, depending on the methods exposed to a particular service and on the struture of the payload that the different services return.

Example 1: Equipment

To export all the equipment from SAP Asset Intelligence Network tenant into a flat file, proceed as follows:

  1. Logon to the SAP Asset Intelligence Network tenant, from the environment that you use to access the data

  2. Send a collective GET request to the Equipment service

    The service returns the list of all equipment in its payload. For each equipment, the payload contains all the fields for which the data is maintained.

  3. Scroll down to the end of the payload and check whether the payload already contains data of all organizations, or if only a subset is loaded in the paging mode

  4. If data is loaded in the paging mode, let the system request the next page or subset of data

  5. Repeat requesting data pages until all the available organizations are loaded

  6. Select the entire payload

  7. Copy and paste the payload data into a text file

  8. Save the text file

Example 2: Attribute Groups

To export attribute groups from SAP Asset Intelligence Network tenant to a flat file and the attributes assigned to the attribute group, proceed as follows:

Mapping on Attribute Group Level

  1. From the environment you use to access the data, logon to SAP Asset Intelligence Network tenant

  2. Prepare two empty text files: one for the attribute group and other for assignments on the attribute level

  3. Send a collective GET request for the IDs of all mapping to the Attribute Group service

    The service returns the list of all mappings in its payload. For each mapping, the payload contains the ID field and few other fields.

  4. For each mapping ID:

  5. Select the entire payload containing the combined results of all the single GET requests from the previous iteration

  6. Copy and paste the payload data into the text file for mappings on the attribute group level

Mappings on Attribute Level

  1. From the environment that you use to access the data, logon to SAP Asset Intelligence Network tenant

  2. Send a collective GET request for the IDs of all mappings to the Attribute service

    The service returns the list of all mappings of attributes in its payload. For each mapping, the payload contains only the ID field.

  3. For each mapping ID:

    • Copy the ID

    • Send a collective GET request for the assignements created based on the current mapping

      The service returns the list of all assignments in its payload.

    • Repeat requesting data pages until all the available assignments are loadedIf data is already loaded in the paging mode, let the system request the next page or subset of page

  4. Select the entire payload

  5. Copy and paste the payload data into the text file for mappings at the attribute level

  6. Save the text file