There is a problem with replication. At the origin of CRM Dynamics there is information in the fields, but they are not being replicated in the PostgreSQL destination.
https://app.skyvia.com/#/76069/packages/123206
Hello Gabriel,
Kindly ask you for providing more details:
Could you please clarify if the problem is common for all the tables selected for replication?
Please provide us with export of one of the problem tables.
Thank you!
I noticed this problem only in that table "csh_analiseimovel".
In the attached image it is very clear which fields are not replicating the content of the data.
Please clear the metadata cache in the Dynamics connection, it should help.
If it doesn't help, please create the test export package of the source table which is not being replicated,
and look if there are values in problem fields.
If there are no values, please provide us with this package ID so that we could test it on our side.
I created an export package. And the problem also occurs, a column is empty.
https://app.skyvia.com/#/76069/packages/124140
Hello Gabriel,
Thank you for providing the test package.
Our development team is investigating the problem.
We will come back to you with the result.
Hello Gabriel,
Our connector is using CRM SDK v9 as API to access Dynamics CRM data:
https://www.nuget.org/packages/Microsoft.CrmSdk.CoreAssemblies/ We performed test runs of your package and also noticed that two columns are absent in the results despite they are specified in the query.
These fields may be accessible only via user interface, not API because of custom access rights for them.
We suggest you to try to contact Dynamics support also to find out if the data for this columns should be returned through CRM SDK.
