Tagged Questions
1
vote
1answer
26 views
OData EDM Missing Property
Using the generic northwind service for OData V4 we are able to make this query:
http://services.odata.org/V4/Northwind/Northwind.svc/Customers?$expand=Orders($expand=Order_Details)
This utilizes a ...
1
vote
0answers
29 views
Dynamics CRM Web API - Are Actions supported via the $batch endpoint?
I have successfully used the $batch endpoint of the Dynamics 365 Web API to create many appointments.
https://myorg.com/api/data/v8.2/$batch
The request body looks something like this:
--...
0
votes
1answer
42 views
How to get option set value from lookup field by using Javascript, OData endpoint
I can retrieve any text field value from Account and set the value to text field in Contact. But got invalid type when I tried to use the same code for option set field.
In this case, ...
1
vote
3answers
132 views
Get optionset text from OData query in CRM web api
https://example.com/crm/api/data/v8.2/accounts?$select=custom_optionset
The above query selects all values in an optionset field in CRM. The return data looks something like this:
{
{
"@...
1
vote
1answer
44 views
CalculateRollupField Dynamics WebAPI
I am trying to call the CalculateRollupField WebAPI call from javascript for microsoft-dynamics. I can't seem to find many examples of the implementation and my attempt at following the documentation ...
0
votes
0answers
39 views
odata Execute crm action
I have action that I try to run. This is the action definition:
<ComplexType Name="vip_MemberProgramResponse">
<Property Name="MembershipId" Type="Edm.String" Nullable="false" Unicode="...
1
vote
1answer
69 views
Update dynamic entity with OData V4 client
Trying to update an entity property with OData v4 client, somehow get this error:
xxx_accountid is navigation property, but I didn't update this property, its type is nullable.
{
"error": {
"...
2
votes
5answers
295 views
How to view traffic from localhost to CRM?
We are using OData Web API CRM 2016 endpoint.
I am creating a request that flows from postman, to a localhost microservice, and then to CRM:
Postman--->localhost microservice--->CRM
I am able to ...
0
votes
0answers
94 views
Talend: OData filter on component tMicrosoftCRMInput (using v2016(odata))
I'm trying to use the component tMicrosoftCrmInput v2016 (odata) to import some data from a Dynamics 365 CRM, and it's working fine, but I can't prefilter data by modifiedon date, I already tried many ...
2
votes
1answer
45 views
Prevent Javascript from replacing beginning of string with NaN?
I am work on some OData query calls to Microsoft CRM and need my query in a very specific format.I am passing parameters to a function which then adds the URL to my query. What I am passing my ...
1
vote
2answers
396 views
Returning count for an odata query
If I have a query such as:
http://myCRMOrg/api/data/v8.1/accounts?$filter=_chr_accountstatusid_value%20eq%2079A024B5-3D7C-E211-8B29-00155DC86B6F%20and%20accountid%20eq%20e929baaf-483b-e711-9425-...
2
votes
1answer
66 views
How to implement RetrieveAttributeRequest via Odata?
In order to get OptionSet information, we can issue a request:
// Create the request
RetrieveAttributeRequest attributeRequest = new RetrieveAttributeRequest
{
EntityLogicalName = Contact....
-2
votes
1answer
55 views
Retrieve Dynamics CRM customer information using ODATA and jQuery
I'm trying to retrieve customer information from Dynamics CRM using jQuery AJAX and ODATA.
$.ajax({
url : oDataUri,
headers : {
Accept: 'image/jpeg, application/x-ms-application, ...
1
vote
1answer
333 views
Authenticate to Dynamics 365 On premise
I am trying connect to Dynamics 365 On-premise with the OData client for .net
I tried to authenticate through basic authentication, however this is not working.
var c = new Microsoft.Dynamics.CRM....
1
vote
1answer
38 views
Dynamics 365 Odata Feed Filter Condition on nested property result error
I want to retrieve data from odata filter condition based on ownerid/Name.
Here is the example of my json format data which I received from odata without any filter condition:
{
activityid: "...
-1
votes
1answer
63 views
how to apply odataqueryoptions against odata endpoint?
CRM 2016 provides an odata endpoint such as:
https://mycrmorg.com/api/data/v8.1/
And it allows you to apply odata filters on it such as:
https://mycrmorg.com/api/data/v8.1/accounts(8308AD1C-1B1A-...
5
votes
1answer
503 views
How to map filter options from ODataQueryOptions to RestRequest
I need to be able to convert from ODataQueryOptions to RestRequest in order to be able to issue a RestRequest with specified filters, and have created the following helper class:
public static class ...
0
votes
1answer
202 views
Changing lead owner via Dynamics Web API
I'm working according to the examples at https://msdn.microsoft.com/en-us/library/mt607875.aspx
I'm able to update other single-value navigation properties with PATCH, i.e.
PATCH [DYNAMICS_URL]/api/...
0
votes
1answer
383 views
Microsoft Dynamics CRM - What is the OData url format to retrieve label of two option set attributes of an entity?
The following Odata url retrieves attributes of an entity.
http:// < host_name>/< org_name>/api/data/v8.1/EntityDefinitions(70816501-EDB9-4740-A16C-6A5EFBC05D84)/Attributes
The entity has ...
4
votes
1answer
252 views
Using OData Client Generator how to select which entities should have proxy classes generated?
I have successfully generated the OData client code using this generator to access my Dynamics CRM WebApi services. Unfortunately for a vanilla organisation it generated a ~30 MB cs file. This is way ...
2
votes
1answer
134 views
Is $top supposed to be murdering odata.nextlink?
I'm attempting to access the odata api in a Microsoft CRM 2011 product. It's working mostly as expected, except that if $top is used then odata.nextlink goes missing. This means that it's impossible ...
7
votes
1answer
635 views
CRM WebApi batch request
With this guide: https://msdn.microsoft.com/en-us/library/mt607719.aspx, I'm trying to create a batch request to delete all quotedetails on a quote.
I'm using jquery's ajax to do the request:
$.ajax(
...
3
votes
3answers
1k views
Creating multiple entities in single request in Microsoft Dynamics CRM (OData)
I know how to create a single entity in single request. However, one requirement wants me to create multiple entities (in my case it's multiple entries in ContactSet). I tried putting array to
POST /...
3
votes
3answers
622 views
Getting only property definitions of entity in OData
I am working on an app which requires communication with OData service (Microsoft Dynamics CRM to be exact). I have a requirement where I only need to know what all properties does the entity have.
...
6
votes
1answer
660 views
Creating Post with Dynamics CRM Web API
A Post entity (https://msdn.microsoft.com/en-us/library/mt607553.aspx) cannot be created using Dynamics CRM 2016 Online Web API.
This payload should create a post on POST /api/data/v8.1/posts
{
"...
1
vote
1answer
68 views
Mapping Lookup field with the variable in the Odata Query URL using Web API
Since Web API is to new to almost everyone, I am also one among them.
The below is the piece of code where the function contains only the
server url and odata query.
I am getting error while while ...
2
votes
2answers
374 views
Unable to assign decimal variable in Javascript [CRM Online 2016]
I've got something puzzling me here and I don't have the experience behind me to spot the issue, so I ask your kind assistance.
I'm developing for CRM Online 2016 and I'm trying to extrapolate a ...
1
vote
0answers
139 views
Testing Authentication to Dynamics CRM OData service
I work on an application that can use OAuth to Authenticate it's self to a CRM OData service. It takes as arguments Client Id, Redirect Uri(because it is a desktop application this is usually ...
1
vote
1answer
599 views
Use extended REST functions like contains in Dynamics CRM
As I noticed, fetching data in Dynamics CRM with REST is a lot faster then with SOAP especially for big data.
Since I'm new to this topic (REST) I want to ask if it's necessary to include any ...
5
votes
3answers
490 views
How to enable gzip compression in Simple OData Client?
I'm trying to perform a query that retrieves information from a CRM Dynamics with the Simple OData Client library like this (C#):
var settings = new ODataClientSettings(resource + "/api/data/v8.0/");
...
3
votes
2answers
472 views
Dynamics CRM - How to handle an odata.nextlink response in .Net
I have the following piece of code that retrieves transactions from a Dynamics CRM (querying with OData):
public async Task<IEnumerable<Transaccion>> GetTransactions()
{
...
1
vote
1answer
708 views
Dynamics CRM Online and Web API : Method Tunneling through POST
I'm using Dynamics CRM 2016 Online and I want to update an entity (a contact for example) using the Web API (odata 4.0) endpoint.
I use Fiddler to test the request. Here are the details of the ...
1
vote
0answers
140 views
DataServiceContext ignoring navigation property when creating new entity
I am trying out the oData DataServiceContext to push data into the oData web api for Dynamics CRM 2016, but it keeps failing because it is omitting navigation properties. In this scenario I am trying ...
1
vote
3answers
154 views
accessing crm changes via odata
I am using odata to query Dynamics CRM Online 2013. I am trying to track changes against particular entities. For example, I want to be able to see Old Values and New Values for Opportunities, as you ...
3
votes
0answers
255 views
How to create many-to-many association with oData in CRM 2013
I am writing an import utility to migrate records from a legacy system into CRM 2013 and I am getting stuck trying to assign users to roles using oData.
From everywhere I can find documentation to do ...
0
votes
1answer
268 views
Dynamics CRM: Odata query that checks if the file attachment file name contains the unicode '#'
Scenario: I have a custom entity with attachments in Dynamics CRM 2011. I want to query those attachments with file name that contains a hash tag ('#'). Say I have attached a few text documents. kdk#...
0
votes
2answers
4k views
Error when filtering on Guid in OData query
I'm trying to filter my OData query result to retrieve the Activity records related to the current Record Id only. I'm using the code below:
var RecordId = parent.Xrm.Page.data.entity.getId();
var ...
12
votes
5answers
4k views
Create annotation to a contact entity in Microsoft Dynamics CRM by API
This question is related to Microsoft Dynamics CRM 2015, that I'm calling through API.
I create contact entity:
POST [organization URI]/api/data/contacts
Content-Type: application/json; charset=utf-...
1
vote
1answer
271 views
Using External data source on Dynamics CRM
I'm creating an Entity in Dynamics CRM 2015 and I want to add new Lookup field and bind that Lookup to an external data source using OData services or other methods that allow me to read data.
Is it ...
1
vote
2answers
2k views
CRM Odata and Javascript
I am making my first CRM project - it's autoupdate field from some other entity. I read a little and gave it a try. I have:
var Code = Xrm.Page.getAttribute("new_codeid").getValue();
var oDataPath = ...
0
votes
1answer
230 views
How to read data using OData service from Dynanic crm in windows phone?
I am totally new in dynamic crm and i have to retrieve data from crm using odata in windows phone. i have written code but its giving error.
private cresol1Context entities;
private readonly Uri ...
1
vote
1answer
953 views
odata filtering based on the property of a relation
I am trying to filter a set based on an aspect of their item relations called "listcontact_association" which represents the N:N relationship between contacts and lists.
I can retrieve the whole set ...
1
vote
1answer
474 views
Dynamics CRM REST oData endpoint support for All and Any
Just wondering if current REST endpoint (2013) supports Any or All for filtering based on child entity:
http://localhost/xrmservices/2011/OrganizationData.svc/AccountSet?$select=Name&$expand=...
0
votes
2answers
2k views
SSIS connecting to CRM OData endpoint dtd error
I'm trying to use the SSIS OData Source component to connect to the CRM OData Endpoint, but it's giving me the following error:
For security reasons DTD is prohibited in this XML document. To ...
0
votes
1answer
2k views
Dynamics CRM OData query filtering on expanded attributes only works if no results come out?
I have a requirement to fetch Price List Item records which adhere to the following requirements:
Filter by a specific PriceList
Filter by a specific currency
Filter by the Name of the related ...
0
votes
1answer
170 views
Listing appointments of a contact
I'd like to list the appointments that a contacts is set to as a required participating party. I'm running the following query in my organization.
The service end point is set up like so.
https://...
0
votes
1answer
430 views
Getting error while Creating Case Record Using Odata Rest Services
I have Ribbon button on CustomEntity. CustomEntity has one text field and account lookup Based on the fields i'm Creating case Record. but record was not creating. could anybody help me on this? where ...
1
vote
4answers
886 views
What is the preferred method of updating Money fields in Dynamics CRM 2013 via Web Services?
I have an entity in CRM that has some Money fields on them. At the time of the creation of the entity there is no value for those fields, so the entity is created and saved. However if I then have ...
0
votes
1answer
743 views
How to get statuscode using Odata in dynamics crm?
By Using Odata Query I am getting the CRM fields. but statuscode is of type OptionSet how do you get that statuscode. I tried the below code its getting Unable to get 0 or Undefined. Could you have ...
0
votes
2answers
746 views
Looking for the odata query that returns the Sharepoint Site URL for a document location for a CRM account
For a given account I need to find the URL of the Sharepoint Site.
I can get the Sharepoint document location, but I really need the URL of the "parent"- Sharepoint Site.
I have come this far:
...
