S3 Integration with Anaplan

Sanku1906

Hi All,

I have a scenario where I need to import a file from Amazon S3 every month but the catch is file name will be "abcd_mm-yy.csv" where every month file name will change this scenario will be automated how can I work on this because using the cloudworks I have to choose file name manually.

Regards,

Venkatesh

Accepted answers

All comments

Misbah

@Sanku1906

I am afraid that it is not the way it is going to work not only in S3 but also in Anaplan Connect. You will have to drop the timestamp from the file because the imports that you might have created in Anaplan need consistent file names across the life span of that particular import.

Just keep the file name as "abcd" and keep archiving the older files if you need them.

Thanks,

Misbah

Miz Logix

Sanku1906

Hi Misbah,

Thanks for your suggestion.

I hope that will help but is there any alternative solution for this?

Regards,

Sanketh

Misbah

@Sanku1906

As far as I know No, if you want to do file based approach. If you are ok with Transactional APIs then there is no need for Anaplan Actions but Transactional APIs have its own cons and can not replace File based transfers or BULK APIs.

Misbah

Miz Logix

TimWard70

Could you run a script on S3 to copy and rename the files without the timestamp? So you'd end up with all the files saved with a timestamp then the most recent ones saved without to allow the upload. amazon s3 - AWS S3 CLI move files with a new name - Stack Overflow

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…