Posts about the simPRO API. Help/support/how-to etc.
Forum rules
- Check the documentation first. Before posting questions, please check the documentation to ensure it doesn't already cover what you need.
- No spam. All automated messages, advertisements, and links to competitor websites will be deleted immediately.
- Post in relevant sub-forums only. Messages posted in the wrong topic area will be removed and placed in the correct sub-forum by moderators.
- Respect other users. No flaming or abusing fellow forum members. Users who continue to post inflammatory, abusive comments will be deleted from the forum after two warnings are issued by moderators.
- Harassment. No threats or harassment of other users will be tolerated. Any instance of threatening or harassing behavior is grounds for deletion from the forums.
- Adult content. No profanity or pornography is allowed. Posts containing adult material will be deleted.
- Bandwidth. All images and signatures must be 500 x 500 pixels or smaller. Posts containing over-sized images and signatures will be removed.
- Illegal content. No re-posting of copyrighted materials or other illegal content is allowed. Any posts containing illegal content or copyrighted materials will be deleted.
-
Test Inc
- Posts: 17
- Joined: Tue Aug 20, 2019 2:34 pm
Post
by Test Inc » Wed Apr 26, 2023 9:43 am
Whenever I add a CSV file to a site or job, I cannot open it through the API for quite some time.
I can open it through the browser, but I need to run some automation on it and I just get the error
Could not open file for attachment.
But if I try later on or the next day, it does open.
I haven't noticed it doing this for other file types, just CSV.
Ian
-
Sindre
- Posts: 493
- Joined: Wed Apr 20, 2022 4:51 am
- Location: Brisbane
Post
by Sindre » Thu Apr 27, 2023 3:25 am
Hi Ian,
I have tried to find possible reasons why you might have problems with CSV files in particular but all files should behave the same.
There can be a short delay between a file is uploaded and when it is available due to load balancing between different servers when using the API but this should be minimal and something you might be able to compensate for in your code by having a small delay before retrieving the file.
If you should continue to have problems please send me a private message with some more details on your build name, how you upload the CSV files, how large the files are and your query trying to retrieve the data again.
Regards
Sindre
API Developer | Simpro Software Group