Notifications
Announcements
No record found.
Hi, in annotation entity I query the notes(annotation) table, when I include documentbody field that holds documents Base64 I get 504 bad gateway from dynamics service.
or By Odata https://mycrm.crm.dynamics.com/api/data/v9.2/annotations?$select=annotationid,documentbody
or or by FetchXml
there are more 10,000 records in the table, I think that query should return 5000 and a cookie doesn't it?.
is it normal to crash?thanks.
Did you try to reduce the number of records in the fetch?
Probable cause is the size of response is high or any custom plugins on retrieve of records
Hi,
Try to write your FetchXml with some specific filtration like below:
<fetch no-lock="true" >
<entity name="annotation" >
<attribute name="documentbody" />
<filter>
<condition attribute="documentbody" operator="not-null" />
<condition attribute="objectid" operator="eq" value="<Put GUID>" />
</filter>
</entity>
</fetch>
put any value in objectid field which related to your notes, and wait for the result
Hello, you need first to convert the documentbody from Base64 to string. Have you tried to do this query with C#?
Thanks!
Community Support Team - Esteban
If this Post helps, then please consider Accept as solution to help the other members find it more quickly.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 170 Super User 2025 Season 2
#ManoVerse 70
Jimmy Passeti 50 Most Valuable Professional
