Azure Data Factory REST API relative URL with Parameter

Question

I am building an incremental load in ADF caling a REST API and using the max date created loaded into my Azure SQL table to retrieve only the records added after that date.

I'm not familiar with API query parameter syntax and struggling with the string query in the relative URL
When I use the literal epoch date the relative URL works but I cant get a parameter to work.

This worked without the parameter
https://api.xxxxx.com/xxxx?limit=200&created_at=%7B%22%3E%22%3A%20"1641382428"%2C%20%22%3C%22%3A%20"9999999999"%7D

The API supplier said the syntax should be this: ?created_at={"gte":"1502039307"}

Ive tried to concatenate but the result is extra characters
@markus.bohland@hotmail.de ('xxxx?limit=200&created_at={"gt":',activity('Lookup_max_created').output.value,'}')

Can someone please advise how I insert a parameter to replace the eopch time of "1502039307"

Answer 1

Hello @Nelia Townsend ,

Welcome to the Microsoft Q&A platform.

Can you please clarify - what character are you seeing extra?

If you want to encode the string - like mentioned in the first part of string :

@encodeUriComponent(concat('xxxx?limit=200&created_at={"gt":activity('Lookup_max_created').output.value,'}'))  

Also, can you should the out of the Lookup activity.

activity('Lookup_max_created').output.value  

Ensure it is string. If not You can use dot operator to access one level down. for instance activity('Lookup_max_created').output.value.lastcreated

In my case to access id I use

activity('Lookup1').output.firstRow.user.id  

Answer 2

Thank you so much. I needed the access to one level down to insert the parameter value correctly.