api call url query problem
i have multiple currency symbol from my supabase. i want to each symbol for get latest price from my twelvedata api in loop. but i cant find a proper way using this symbols.
do you have any solution? thanks
Solution:Jump to solution
i got the solution. if I use loop.item end of the url cause interesting an error.
3 Replies
AI Support Bot Information
<@395574845494001666> you can react on the relevant answer (message) with a ✅ in this thread when you think it has been solved, by the bot or by a human!
Anyone can react on this message with a ❌ if the GPT bot is unhelpful or hallucinating answers.
Please note: Team members will review and answer the questions on best efforts basis.
AI Response
To use multiple currency symbols from your Supabase database and fetch the latest price from the Twelve Data API, you can implement a looping mechanism in your BuildShip workflow. Here's a general outline of the steps you can take:
1. Fetch Symbols from Supabase:
- Use the Supabase nodes within BuildShip to query and fetch the symbols from your database. Ensure you have the correct query to retrieve the currency symbols you need.
2. Iterate Over Symbols:
- Implement a loop within your workflow that processes each symbol one by one. You can use a looping mechanism provided by BuildShip to iterate over the array of symbols fetched from Supabase.
3. Fetch Latest Prices from Twelve Data API:
- Within the loop, for each symbol, make an API call to the Twelve Data API to get the latest price.
- You can use the HTTP Request node in BuildShip to make REST API calls to Twelve Data with the required parameters including your symbol.
4. Store or Process Results:
- After obtaining the latest prices, store them back in your database or process them as needed for your application.
Since you need to integrate multiple services, here are some nodes that might help you:
- Supabase Nodes: Use these to interact with your Supabase database, specifically fetching the symbols.
- Loop or Iteration Nodes: These nodes can help in iterating over your fetched symbols.
- HTTP Request Node: To make API calls to Twelve Data.
If you need a template or specific examples, you might find a pre-built workflow helpful. Unfortunately, if that's not available directly, you may need to create a custom workflow using the steps outlined above. If you have any further questions or need more detailed guidance, feel free to ask.
BuildShip AI Support
Solution
i got the solution. if I use loop.item end of the url cause interesting an error.