Forum

Issue with limit on...
 
Notifications
Clear all

Issue with limit on number of sources in Connections and Query

2 Posts
2 Users
0 Reactions
231 Views
(@ladyc)
Posts: 1
New Member
Topic starter
 

Hello - so I have been using an Excel table with Queries and Connections to connect to external data (API of cryptocoins).

Everything worked fine UNTIL I added the API of more than 50 coins in the source line. When I load the table back into Excel, only 50 lines appear - the others are not showing. I double-checked and the source is correct.. so I suspect there is a some kind of a limit somewhere... but not sure where to look!

Thanks for your advice

LadyC

 
Posted : 08/09/2021 9:36 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Cecile,

Welcome to our forum! This will be a limitation of the API. Often companies limit API calls to reduce load on their servers. You would need to address this with them.

Mynda

 
Posted : 08/09/2021 8:50 pm
Share: