Solved

Using a field from an ERP to use as a Parameter for a REST call

  • 27 January 2023
  • 2 replies
  • 59 views

Badge +1

I 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.

 

icon

Best answer by Thomas Lind 30 January 2023, 11:39

View original

2 replies

Userlevel 5
Badge +5

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?

Userlevel 6
Badge +5

Hi @hugo.winkelhorst 

Can 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 :)

Reply