What are you trying to achieve?
I’m working on a Make scenario to fetch loads from SuperDispatch using their API, specifically for orders delivered within the last 24 hours. The SuperDispatch API provides paginated data, so I’m using pagination to ensure I retrieve all relevant records. Once the data is in Make, I need to filter and compare it with existing records in Zoho CRM to prevent duplicates, using the Load ID
field as the unique identifier.
The challenge I’m facing is setting up the correct filter in Zoho CRM to identify and skip records that already exist based on the Load ID
. I’ve tried using various text operators (in Zoho Search only text operators is ok), but duplicates are still being created. Any advice on configuring Zoho CRM search or filters correctly in Make to ensure only new loads are added?
Steps taken so far
I made scenario step by step by guide of pagination, but im struggling 2 days and chatgpt cant help me
Here’s an overview of each module in scenario
-
Tools (Set Multiple Variables) - This module initializes any variables needed for the scenario. These variables might include parameters like the start time for filtering loads within the last 24 hours or initial values for pagination.
-
Repeater - This module is used to repeat actions in the scenario for a specific number of times or until a condition is met. It could be set to handle multiple pages of API results, ensuring that each page of loads is processed.
-
Get Page URL (Set Multiple Variables) - This module captures the URL for the next page in the API response, enabling pagination. It likely checks if there’s a “next page” link and sets it as a variable to fetch the following batch of loads.
-
Get Access Token (Make a Request) - This module makes an API call to SuperDispatch to retrieve an access token. This token is essential for authenticating further requests to the SuperDispatch API and may have to be refreshed periodically.
-
Get Loads by Access Token (Make a Request) - With the access token, this module retrieves loads from the SuperDispatch API. It includes filters for:
Status: set to “delivered.”
Delivery completed_at: only loads delivered in the last 24 hours.
-
Next (Set Multiple Variables) - This module captures the “next” URL for pagination from the API response if additional pages are available. It allows the scenario to keep looping through pages until all loads are retrieved.
-
Iterator - This module breaks down the list of loads into individual items so that each load can be processed separately in subsequent modules. This is necessary for checking each load’s ID individually in Zoho CRM.
-
Search Load ID in Zoho CRM (Search Objects) - For each load, this module searches in Zoho CRM by Load ID to determine if the load already exists. It helps prevent duplicate entries. If the load is found, it proceeds to the next item without creating a duplicate.
-
Filter (If Not Exist) - This filter is applied to check if a load doesn’t exist in Zoho CRM. Only loads that are not found in the previous step proceed to the “Create Load” step.
-
Create Load in Zoho (Create an Object) - If a load is confirmed as unique (i.e., it doesn’t exist in Zoho CRM), this module creates a new record in Zoho CRM with the relevant load details.
I tried a lot of filters, but still i have multiple records in Zoho
What condition and text operator i should use after Zoho Search CRM and before Zoho create object? (last 2 modules)