Finance | Project Operations, Human Resources, ...

Fetch value from X++ for oData Filter query

(0) Share

Report

Posted on by aayushii

135

I am trying to find the value of Odata link:

https://F&Olink/data/Dataentityname(InventSiteIdList='inv1', dataAreaId='dat')/Microsoft.Dynamics.DataEntities.GetColorsByAvailability2
I am using the below code :

[SysODataActionAttribute(/GetColorsByAvailability2/, false),
SysODataCollectionAttribute(/InventSiteIdList/, Types::String),
SysODataCollectionAttribute(/return/, Types::String)]
public static str GetColorsByAvailability2(Str _InventSiteIdList)
{
info(strFmt(/%1 invent/,_InventSiteIdList));
return _InventSiteIdList;
}

also method with parameters like:

[SysODataActionAttribute(/GetColors/, true),
SysODataCollectionAttribute(/return/, Types::Record, /CarColor/)]
public List GetColorsByAvailability(boolean onlyAvailableVehicles)
{
if(onlyAvailableVehicles == noyes::Yes)
{
info('yes');
}
else
{
info('no');

}
List returnList = new List(Types::Record);
// do something
return returnList;
}
I wanted to find the method from where I can the value of odata. And where should I put breakpoint to debug and find the values of odata filters

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Martin Dráb 239,124 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Neither of them will give you OData filters.

GetColorsByAvailability() is an instance method, therefore it has a reference to an entity record (in a variable called this) and a single parameter: onlyAvailableVehicles. Of course, if you selected a record by a field value, you can see the value in the field (e.g. this.InventSiteIdList).

GetColorsByAvailability2() is a static method and all it knows is the value of its parameter (_InventSiteIdList).

Was this reply helpful? Yes No
aayushii 135 on at

Like (0)

Report
Copy link

Link copied!

by URLHi Martin,

Thank you for the quick response.

I wanted to know how to call GetColorsByAvailability2() using URL what will be the syntax for it.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,124 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

As I remember, the URL should be [Organization Root URL]/data/[DataEntityCollectionName]/Microsoft.Dynamics.DataEntities.GetColorsByAvailability2.

Parameters should be in a JSON object passed in the request body.

Was this reply helpful? Yes No