web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Missing fields when re...
Service | Customer Service, Contact Center, Fie...
Answered

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

(0) ShareShare
ReportReport
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)
  • Verified answer
    prt33k Profile Picture
    prt33k 6,907 on at

    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:

    pastedimage1611793742650v1.png

  • RDaudt Profile Picture
    RDaudt 120 on at

    Thanks, Prateek.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
NeerajPawar Profile Picture

NeerajPawar 31

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 19 Super User 2026 Season 1

#3
11manish Profile Picture

11manish 16

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans