Using ID from Stream 1 in Stream 2

Summary

User seeks guidance on how to utilize the ID from Stream 1 (Keywords) in Stream 2 (Top 100 Serp) API endpoint, including dynamic date handling for the request.


Question

Hi I have 2 stream,
stream 1 return ID and other columns
stream 2 I want to use the data from ID in stream 1, how should I do that?

stream 1 name = Keywords
stream 2 name = Top 100 Serp

stream 2 url end point = https://api4.seranking.com/competitors/top100/2622739/?date=2024-11-14&site_engine_id=1037566&keyword_id=112266061

where keyword_id = stream 1 - ID

and I also want to include dynamic date where it always use today()-2 (2 days ago). (the stream refresh everyday)

Appreciate the help



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

['stream-1', 'stream-2', 'id', 'dynamic-date', 'api-endpoint']