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 / 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 Community Member

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:
Work Order
I have the same question (0)
  • Suggested answer
    Dynamics365 Rocker Profile Picture
    Dynamics365 Rocker 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