Coalesce on Import Set/Transform Map fed by REST API

[Vinicius Luz1]

Hey Guys,

This should be a simple one for you experts.

I have an Import Set+ Transform Map to load projects in servicenow [pm-project] table.

I'm inserting data to be transformed and inserted in the project table based on what comes on a payload from my project management third party tool.

I do have the coalesce set to true to a unique id coming from the 3rd party tool but still seeing projects with the same ID being double inserted.

[Ankur Bawiskar]

@Vinicius Luz1 

which field on pm_project are you using for coalesce?

are you sure it's exact value and no leading or trailing spaces in the incoming field?

[Vinicius Luz1]

The field is called u_project_id in the import set and u_legacy_ticket on the pm_project

Thanks,

Vini