File Pattern Matching in DataPrep Amazon S3

File Pattern Matching in DataPrep Amazon S3

I'm trying to automate the refresh of a simple CSV file in a folder in a bucket on S3. .
I'm using the advanced selection because 


I have 2 different files I need to import:
Stores_20240208.csv
People_20240208.csv

I can connect to the bucket Using the Bucket name - e.g. my-bucket
I can connect to the specific folder using the folder name WITH a hanging slash - e.g. my-folder/

In the "File pattern" field, according to the example (e.g. Filename_*.zip), I should be able to enter either of the following:

Stores_*.csv
or
People_*.csv

and with "Fetch new files based on modified time", I should be able to retrieve the most recent file. I do not. I get no file.

I get an error:
No file found for the given regex pattern. Please check whether the pattern specified is correct.

I'm following the instructions given. Why is my pattern incorrect?

HOWEVER

I can retrieve a non-specific file when I use the file pattern ".*" - > .*


Regardless of whether I've selected "Fetch new files based on modified time", it will always return the oldest file in the folder.

What am I doing wrong? 


      Zoho Developer Community








                                Zoho Desk Resources

                                • Desk Community Learning Series


                                • Digest


                                • Functions


                                • Meetups


                                • Kbase


                                • Resources


                                • Glossary


                                • Desk Marketplace


                                • MVP Corner


                                • Word of the Day



                                    Zoho Marketing Automation
                                            • Sticky Posts

                                            • Announcing DataPrep 2.0 Beta!

                                              Being data-driven is an important end goal for all organizations, because when businesses can manage, analyze, and make actionable decisions based on data, they have a competitive advantage. With that said, how confident are you in making business decisions
                                            • Zoho CRM connector's export functionality enables end-to-end CRM data pipeline

                                              We're thrilled to announce an update to our Zoho CRM connector that will enable you to create data pipelines to Zoho CRM. The public beta of "export to Zoho CRM" is now available, and can be enabled for users requesting it via email. Using the feature,
                                            • Zoho DataPrep is now launched!

                                              We are excited to announce the launch of Zoho DataPrep – An advanced self-service data preparation and data pipeline service.  Introducing Zoho DataPrep Zoho DataPrep helps organizations prepare data by automatically identifying errors, discovering data


                                            Manage your brands on social media



                                                  Zoho TeamInbox Resources

                                                    Zoho DataPrep Resources



                                                      Zoho CRM Plus Resources

                                                        Zoho Books Resources


                                                          Zoho Subscriptions Resources

                                                            Zoho Projects Resources


                                                              Zoho Sprints Resources


                                                                Qntrl Resources


                                                                  Zoho Creator Resources


                                                                    Zoho WorkDrive Resources



                                                                      Zoho Campaigns Resources

                                                                        Zoho CRM Resources

                                                                        • CRM Community Learning Series

                                                                          CRM Community Learning Series


                                                                        • Tips

                                                                          Tips

                                                                        • Functions

                                                                          Functions

                                                                        • Meetups

                                                                          Meetups

                                                                        • Kbase

                                                                          Kbase

                                                                        • Resources

                                                                          Resources

                                                                        • Digest

                                                                          Digest

                                                                        • CRM Marketplace

                                                                          CRM Marketplace

                                                                        • MVP Corner

                                                                          MVP Corner







                                                                            Design. Discuss. Deliver.

                                                                            Create visually engaging stories with Zoho Show.

                                                                            Get Started Now