1. If I pull data from sql and exported to excel, upload it to skyvia and do upsert to dynamics 365, works fine.
If I try to do it straight from sql to skyvia is where it fails. It looks to be invalid data type.
When I'm doing upsert, if record doesn't existing in dynamics, it create a new rcord, if there is, it'll update with new information.
-Dynamics have a accountid that is unique to each row that is generate by dynamics. So I set customerID as a lookup.
I'm not able to do this with targetlookup since it's invalid data.
What are my options? I started testing some expression, but didn't work.
Attachment is show below if I upload via excel vs sql directly.