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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Field Service forum / Which entities to use ...
Field Service forum

Which entities to use data export services and relationships

(0) ShareShare
ReportReport
Posted on by

Hi,

Which entities do I need to bring across via data export services that will tell me the following:

Case Number

Case Number Status

Work Order

Work Order Status

Booking Resource ID

Booking Resource Name

Parts Used

I also need to know what is the primary key and foreign key so I will be able to join to them when brought over across using data export services.

Thanks

Categories:
I have the same question (0)
  • Suggested answer
    Dynamics365 Rocker Profile Picture
    7,755 on at

    Data Export service is used to download CRM online data in Azure SQL server.

    You will get all entities or give a try at least.

    Primary key is entity id and foreign key in CRM is lookupid.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Field Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans