Setup the Filter in the OData coming from NAV2015 Query
rxqrxqrxqrxqrxq
Member Posts: 22
Could some help me with this:
I create a nav 2015 Query based on the Warehouse Entry (Fields:Item No., Location code,Bin Code, Quantity---Grouped fields:Item No., Location Code, Bin Code, and the Sum field is Quantity) with Group Function,
Name is "Lot Numbers by Bin Test",
and then I publish the OData Webservice based on this query, and the OData service Name is also "Lot Numbers by Bin Test",
I plan to get the Data through EXCEL->Power Query, and I want to set some filter for the Item No.
then I update the Power Query like the following:
////////////////////////////////////////////////////////////////////////////////->
let
Source = OData.Feed("http://jerry-pc.bejo.local:7048/DynamicsNAV80/OData/Company('Bejo Foreign Company')/Lot_Numbers_by_Bin_Test$filter=Item_No eq '19808500'")
in
Source
///////////////////////////////////////////////////////////////////////////////<-
But I get his Error:
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////->
DataSource.NotFound: OData: Request failed (404): The remote server returned an error: (404) Not Found. (Resource not found for the segment 'Lot_Numbers_by_Bin_Test$filter=Item_No eq '19808500''.)
Details:
http://jerry-pc.bejo.local:7048/Dynamic ... pany('Bejo Foreign Company')/Lot_Numbers_by_Bin_Test$filter=Item_No eq '19808500'
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////<-
I used to get the filtered data from the OData which is coming from Page Object, but How can't I get the data from it from Query?
I have tried with the address:"http://jerry-pc.bejo.local:7048/DynamicsNAV80/OData/Company('Bejo Foreign Company')/Lot_Numbers_by_Bin_Test", and it is working
I think I am wrong about adding the filter part.
Can anyone tell me how to setup the filter to the OData which is coming from Nav 2015 Query.
BTW I have tried to setup the "Filter" type in the Query and use this Filter type to filter the data ---also failed.
thanks.
I create a nav 2015 Query based on the Warehouse Entry (Fields:Item No., Location code,Bin Code, Quantity---Grouped fields:Item No., Location Code, Bin Code, and the Sum field is Quantity) with Group Function,
Name is "Lot Numbers by Bin Test",
and then I publish the OData Webservice based on this query, and the OData service Name is also "Lot Numbers by Bin Test",
I plan to get the Data through EXCEL->Power Query, and I want to set some filter for the Item No.
then I update the Power Query like the following:
////////////////////////////////////////////////////////////////////////////////->
let
Source = OData.Feed("http://jerry-pc.bejo.local:7048/DynamicsNAV80/OData/Company('Bejo Foreign Company')/Lot_Numbers_by_Bin_Test$filter=Item_No eq '19808500'")
in
Source
///////////////////////////////////////////////////////////////////////////////<-
But I get his Error:
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////->
DataSource.NotFound: OData: Request failed (404): The remote server returned an error: (404) Not Found. (Resource not found for the segment 'Lot_Numbers_by_Bin_Test$filter=Item_No eq '19808500''.)
Details:
http://jerry-pc.bejo.local:7048/Dynamic ... pany('Bejo Foreign Company')/Lot_Numbers_by_Bin_Test$filter=Item_No eq '19808500'
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////<-
I used to get the filtered data from the OData which is coming from Page Object, but How can't I get the data from it from Query?
I have tried with the address:"http://jerry-pc.bejo.local:7048/DynamicsNAV80/OData/Company('Bejo Foreign Company')/Lot_Numbers_by_Bin_Test", and it is working
I think I am wrong about adding the filter part.
Can anyone tell me how to setup the filter to the OData which is coming from Nav 2015 Query.
BTW I have tried to setup the "Filter" type in the Query and use this Filter type to filter the data ---also failed.
thanks.
0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions