Again, i got this issue with 1 of my file which had only 28k records and it consumed whole limit for the day and stopped in between after reaching the limit of 10000 api calls.
I checked about the api calls via skyvia and there is no long text or many lookups(only 1 lookup in the mapping). Then how it can consume the limit of 10000 api calls.
could you please check if something is wrong in the job #40133155. I am not able to work with this limitation and also my file runs very slow. I am reading this file from SFTP server but I dont think that SFTP location has anything with speed or api call limits.
Please suggest, I have so many files like this to upload in Salesforce.