+1I need to be able to call an API using a reference number from the ERP system ( which is already in the ODX) as part of the URL. It looks like the Dynamic parameters as descibed on the old support site could work. However it is stated that this will only work in the old fashioned business unit. Is there a solution that would work in the ODX or would a Power Automate/Logic App be the only solution.
Best answer by Thomas Lind
Hi Hugo
I am not sure this will necessarily work in this instance, but you can do free form queries
https://cdn.cdata.com/help/DWH/ado/pg_FreeForm.htm
So you can make a query table that sets the input.
For example I have a REST API called Fixer.io that gives currencies based on a date. I mention it in my RSD guide.
I did this query.
SELECT [base_currency], [date], [historical], [exchange_rate_to_USD], [exchange_rate_to_GBP], [exchange_rate_to_AUD], [timestamp] FROM [REST].[Currencies]
WHERE datein = cast(cast(GetDate() as date) as string)I add a Where clause with the input field, just as before. The issue is that I can’t use dynamic variables and I could newer figure out how to get a date that showed yesterday.
What is it you need to add as an input?
+5Hi Hugo
I am not sure this will necessarily work in this instance, but you can do free form queries
https://cdn.cdata.com/help/DWH/ado/pg_FreeForm.htm
So you can make a query table that sets the input.
For example I have a REST API called Fixer.io that gives currencies based on a date. I mention it in my RSD guide.
I did this query.
SELECT [base_currency], [date], [historical], [exchange_rate_to_USD], [exchange_rate_to_GBP], [exchange_rate_to_AUD], [timestamp] FROM [REST].[Currencies]
WHERE datein = cast(cast(GetDate() as date) as string)I add a Where clause with the input field, just as before. The issue is that I can’t use dynamic variables and I could newer figure out how to get a date that showed yesterday.
What is it you need to add as an input?
+5Can you please help us mark the best answer if you are satisfied with Thomas answer above?
If you have any follow up questions please let us know :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
