Email Query component limit to 100 most recent emails in Matillion for Snowflake, is there a way to extract the whole email dataset?

Matillion ETL
1

I am using Matillion for Snowflake, Email Query component to connect to an Outlook account.

I using a simple query of Select * from INBOX and it always brings me the last 100 emails.

I've got around 1K emails, and I've tried to use the ID < X ; but it doesn't bring me anything. It seems that it can only see the 100 mos recents from the email.

 

Has anyone come across this limit, and know how to get around it?

2

Update on this one, this was corrected with one parameter in the ConnectionOptions of the Email Query matillion component: maxitems.

As per documentation, the default is 100.

https://s3-eu-west-1.amazonaws.com/matillion-documentation/data+models/Email_DM.html#RSBEmail_p_MaxItems.htm

 

Once identify how many emails I wanted to extract, I modified this to 1000 and was able to obtain the last 1000 emails in my INBOX.