How to dynamically pass IDs from one API response to a second API call in Zoho DataPrep?

How to dynamically pass IDs from one API response to a second API call in Zoho DataPrep?

Hi Team,

I am setting up a global consolidated reporting pipeline in Zoho Analytics (India) using Zoho DataPrep as the ETL engine. I am pulling data from multiple Zoho Books Data Centers (US, Singapore, India) thats why i used the URL Source (OAuth 2.0)  instead on standard direct connection menthod of zoho books.


The Problem: Dynamic API Request Chaining

I need to fetch Line Items from Zoho Books across multiple Data Centers (IN, US, SG). This requires a two-step process:

  1. Call A: Get a list of Sales Orders.

  2. Call B: Use the salesorder_id from Call A to call a specific detail URL. To get line items of sales order.

My Setup

  • Source: Zoho Books (Multi-DC: .in and .com)

  • Middleware: Zoho DataPrep 2.0 (Visual Pipeline)

  • Destination: Zoho Analytics

  • Authentication: Server-based App (Client ID/Secret) with ZohoBooks.fullaccess.ALL scope.

My Questions:

  1. What is the correct way to visit a second URL per row within the DataPrep pipeline ? 

  2. Where exactly is the Code Studio or Custom Transform option located in the new DataPrep 2.0 interface for this purpose?

  3. If Deluge isn't the best way, is there any way in DataPrep to join these two API calls without hitting heavy rate limits?