"How to Verify Third-Party Data Retrieval by Filtering Work Order Reports"

First, Understand How the Integration Platform Retrieves Data from Third-Party APIs via Call Logs

1. Each time the system calls a third-party batch query API, it retrieves data within a specific time range, which is displayed in the “Query Time Range” column.
2. The Input Parameters section shows the parameters passed during the query. Here, you can identify which date field was used for the query (e.g., the last modified time of the data). If the API has been customized, verify the field in the API settings.
3. The Returned Results section displays the data sent back by the third-party API to the Integration Platform. This is where you confirm what data was actually returned.

picture coming soon:

Step 1: Use the Data Verification Tool to Identify Missing Data IDs

Start by verifying the third-party data IDs that were not imported into the temporary database. Sample a few IDs and proceed with the following steps to pinpoint the issue.

Step 2: Narrow Down the Scope by Confirming the Data Timestamp

Due to the large volume of logs, first narrow the search range by confirming the data timestamp:

1. Identify the query field:
   Go to Integration Flow Details > Run Overview > API Call Logs, then check the Details > Input Parameters of the most recent log to see which timestamp field was used for the query.

picture coming soon:
Integration Flow Details > Run Overview > API Call Logs

picture coming soon:
Details

picture coming soon:
Input Parameters

1. Check the data in the third-party system:
   Use the retrieved data ID to verify the relevant information in the third-party system, particularly the timestamp field used in the query.

1. Filter logs by timestamp:
   Narrow down the log range to identify the relevant API calls.
   Example: This data should have been returned in one of these three calls.

picture coming soon:

Step 3: Search the “Returned Results” to Confirm Data Retrieval

After narrowing the log range, search the Returned Results to verify if the data was returned.

• If no results are found: The API did not return the data.
  picture coming soon:

• If results are found: The API returned the data, but it was not imported. Submit a Work Order to resolve the missing data issue.
  picture coming soon: