Best answer

How do I load specific S3 key data into Salesforce and extract CSV Data for further steps?

  • 25 July 2023
  • 4 replies
  • 79 views

Userlevel 1

Hello! How can I load data dynamically from S3 to salesforce? I saw that I can choose a s3 bucket but I want to reduce the scope to only one key and not all the bucket. Also, how can I extract all the data from csv file in S3 and reuse it in further steps? Thanks in advance.

 

icon

Best answer by Troy Tessalone 25 July 2023, 21:18

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @Arturo 

Good question.

Try adding a Filter as Step 2 in the Zap: https://zapier.com/apps/filter/help

 

Userlevel 7
Badge +14

@Arturo 

For the CSV File, try using this Zap action: Formatter > Utilities > Import CSV File

Help: https://help.zapier.com/hc/en-us/articles/8496060898701-How-to-Import-CSV-Files-with-Formatter#common-problems-with-the-import-csv-file-utility-0-1

Userlevel 1

Thanks. Troy! Both answers worked, thanks a lot!

Userlevel 7
Badge +6

Hi @Arturo,

Awesome! I’m glad Troy was able to help you out.

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 😊