Forum Discussion

LucieCL's avatar
LucieCL
New Member
1 year ago

Power query does not upload all records

Hi all,    I have a problem with uploading records via API from Airtable. It only upload 199 records. I use the code shared from Airtable, see below. I use this code over the year but now I have up...
Need Help
LucieCL's avatar
LucieCL
New Member
1 year ago

Thank you for the reply. But I use this code for over a year and it was working untill today.

 

According to the Airtable API changelog, the latest change was made in November 2024 and it was about this:
Multiple OAuth token refresh requests now only invalidate access if the number of requests exceeds 10 per second

So I do not think that it is about the API connection. Do you have any other idea why this happen?

Thanks!

ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
1 year ago

Is this a one time issue or have you seen it persist several days? 

  • LucieCL's avatar
    LucieCL
    New Member
    1 year ago

    It is happening since today. Yesterday is was alright.

    • ray_aramburo's avatar
      ray_aramburo
      Icon for Super User rankSuper User
      1 year ago

      I would give it one day to monitor the issue, might be because the API is throttled/has a downtime, because they are updating the API or any other factor. If issue persists, I would start digging deeper. I can't replicate your code due access and permissions but I'll check the documentation to see what I can find.