Home > database >  Azure Logic apps getting all Watchlist Items for a given watchlist
Azure Logic apps getting all Watchlist Items for a given watchlist

Time:12-22

I'm trying to get all Watchlist Items for a given watchlist using the connector ( which still in preview).

enter image description here

I have 150 elements in my Watchlist, I'm getting the first 100 items correctly but I'm not getting the 50 last items, I'm pretty sure that the connector is not handling the pagination, in the output I have a "nextlink", but I don't know if I can use it to get the resting items.

Does anyone have a solution ?

enter image description here

CodePudding user response:

Sharing the same as discussed enter image description here

enter image description here

You need to convert the response $content property to enter image description here

In the query I run "_GetWatchlist('Watchlistname')" to get all the watchlist items, this way I was able to get all the items correctly.

enter image description here

  • Related