In Integration Center, need help in filtering the payload on a field

[niyatijain2]

Hello All,

In Integration Center, trying to filter an email field with 2 conditions - convert it to lower case and then only fetch those who ends with - '@---.com' (here --- can be a company name).

Have tried using a calculated field and calculated filter but not able to find the solution for this, can anyone in the community know the solution for this?

[T_Eva]

Hi @niyatijain2 , hope you're fine.

Below is a logic that worked before, but was not tested recently.

Please check if you have tried to create your configuration like this, and then confirm if this suggestion can help you:

1 - Create a Calculated Field:

In your Integration Center job, add a new Calculated Field.
Name it "LowerCaseEmail" or something similar.
Use the following formula to convert the email to lowercase:
LOWER(email), Where email is the name of your original email field.

2 - Set up the Filter:

In the "Filters" section of your Integration Center job, create a new filter.
Use the following condition:
LowerCaseEmail ENDS_WITH '@gmail.com'

*LowerCaseEmail is the name of your calculated field from step 1.

3 - Apply the Filter:

Ensure the filter is activated for your job.
This should work restricting the data to only include records where the email (in lowercase) ends with '@gmail.com'.

****************

Regards,

Thiago Eva

[niyatijain2]

Hello Eva, I had tried this initially but the issue I am facing is after the calculated field is created, in the advanced filter section, the calculated field doesn't come as one of the options. Therefore, I came to the community if they have faced the same issue and have any solution to it.