What is the Route Details -> Description entity?

(0) Share

Report

Posted on by HerrimanCoder

I am trying to find the F&O entity name and its attributes that correlate with this:

Route details -> Description -> (Type, Description)

I have done OData queries against a number of different route-operations related entities and I cannot find where those 2 attributes live. Thanks in advance for any help.

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Danny Bilodeau 4,918 Super User 2025 Season 2 on at

Like (0)

Report

Hello Herriman,

Dont know if this will help, but you would find this in the Docuref table.

This is a Document Type "Note", likely configured to be saved in the database (see Organisation Administration > Document Management > Document type). In the Docuref table, you will find the reference to the reference table number.

There is a D365 entity labelled "BusinessDocumentDocuRefStaging" that seems to have the same content as the Docuref table. You could confirm by exporting the content and locating your record.

Regards,

Danny

Was this reply helpful? Yes No
AnithaEswaran 2,032 on at

Like (0)

Report

Hi,

You can get the details from AOT form about the tables used.

If there are no OOB entity , a custom one can be created similar to 'CutomerAttachmentsEntity'

Was this reply helpful? Yes No
HerrimanCoder 62 on at

Like (0)

Report

Thank you Danny and Anitha. With your help I got 1 big step closer. I was able to find my record thusly:

myinstance.sandbox.operations.dynamics.com/?mi=SysTableBrowser&prt=initial&limitednav=true&TableName=DocuRef&cmp=MEX (and then I filtered by the 'Name' column and found my exact record)

But now I need to find that same record via OData query, but I cannot find the entity record that correlates with the DocuRef table. For example, if there was an entity named DocuRef then I should be able to query it thusly:

myinstance.sandbox.operations.dynamics.com/data/DocuRefs?$top=1

The message "No route data was found" means that entity doesn't exist. Any idea what the entity is actually named, or how I could discover that?

Was this reply helpful? Yes No
Suggested answer

Danny Bilodeau 4,918 Super User 2025 Season 2 on at

Like (0)

Report

Hello Herriman,

Try this for entitty name: BusinessDocumentDocuRefs.

Was this reply helpful? Yes No
HerrimanCoder 62 on at

Like (0)

Report

Hi Danny - I was looking at that one earlier, but moved on because I couldn't find my particular record. Here is a random record from BusinessDocumentDocuRefs:

I tried finding my record thusly:

myinstance.sandbox.operations.dynamics.com/data/BusinessDocumentDocuRefs?$filter=Notes eq 'Nate J testing'

The attribute "Notes" seems the only plausible match, but it yields no results with my filter as shown above. The field in the DocuRef table is "Name". I tried several other STRING-looking attributes in that entity and they either find no match, or throw an error when attempted.

How can I find my record via OData query?

Was this reply helpful? Yes No
Danny Bilodeau 4,918 Super User 2025 Season 2 on at

Like (0)

Report

Hi HerrimanCoder,

I am afraid that I am not worth much into sql queries and the like. One of your fellow developpers (Anitha Eswaran) will be better placed.

Was this reply helpful? Yes No
Verified answer

AnithaEswaran 2,032 on at

Like (1)

Report

Hi ,

This is because Public property of Docurefentity is set to No. This means you will not be able to read/write via odata or DMF

I suggest you to create a new entity similar to CustomerAttachementEntity and customize it as per your requirement.

Was this reply helpful? Yes No
HerrimanCoder 62 on at

Like (0)

Report

Thank you Anitha.

Was this reply helpful? Yes No