Share
Report
321I'm creating an integration between CRM and BC using the Notes table attached to a resource. There are a number of records associated to a specific resource which are recorded in the RecordLinks table, and the goal is to be able to read the note text via a Web Service to then move that data into CRM.
When I create a query based on the RecordLinks table, it fails on rendering in the page (?query=XXXXX) whenever the BLOB field is included. I'm assuming I need to somehow convert the BLOB contents (which is a very long text string) into something else to be able to publish it to the query, however I'm not sure how to actually do so. The MS documentation hasn't helped, and reaching out to MS support on this suggests asking the community, so I'm not sure if that means it's not possible to do or they just don't have an answer on how to. Hoping somebody here has run into this before.
Short version of the question is, how do I interact with a BLOB field in a query?
Any direction/insight/suggestions is appreciated.
Thanks
Garrett
All responses (
Answers (
