Missing fields when retrieving data from D365 online with SSIS and KingswaySoft

(0) Share

Report

Posted on by RDaudt

120

Hi everyone.

We have Dynamics 365 online. We are building a SSIS process that retrieves data from D365 and stores in an on-prem SQL server. We are using KingswaySoft together with SSIS.

The process completes with no error and retrieves all the records for the entities we are working with. However, for many name-related columns, the data is not retrieved. An example is column emailsendername in the email entity. No data is retrieved for this column when we run the SSIS package. It doesn't matter if we are using the Web API or the SOAP endpoint.

Has anybody dealt with this issue?

Any input is appreciated.

Thanks

Roque Daudt

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

prt33k 6,907 on at

Like (0)

Report

Hi,

The name column you are referring are virtual and are generated at runtime so to query them directly will not yield any result.

To get the name, you need to use link query and do a outer join... something like this:

<fetch top="50" >
<entity name="account" >
<attribute name="modifiedbyname" /> //This will not be returned.
<link-entity name="systemuser" from="systemuserid" to="modifiedby" link-type="outer" alias="usr" >
<attribute name="fullname" />
</link-entity>
</entity>
</fetch>

result:

Was this reply helpful? Yes No
RDaudt 120 on at

Like (1)

Report

Thanks, Prateek.

Was this reply helpful? Yes No