We integrated Salesforce and Asana via custom API. I have created a few custom fields (project status & phase) in the portfolio that reflects in each project as well, assuming those custom fields are created at the project level.
The integration job runs every 3 hours to sync these custom fields (project status & phase) to the associated Salesforce project based on the ‘last modified date - ‘today’’. This job is not picking up these custom field updates to Salesforce since the last modified date is not getting updated even though I update them today.
Eg: Project name: Test V1
Old value - Project status : Pending ; New Value - Project status : Active
Old Value - Project phase: Prelaunch ; New Value - Project phase: Launch
I updated above fields today morning 1st August, 2022 at 9 AM and the job ran at 9:30 AM to sync to the updates. But these updates weren’t synced with SF. When I troubleshot, I found the last modified date was 19th July, 2022. i.e., from the previous update, I believe.
On the other hand, I updated the project name : Test V1 to Test V2 and found the last modified date was updated to 1st August, 2022.
Does this mean the custom fields are not project level fields? If so, what should I do to pick these custom fields during the sync?
Thanks in advance!