Executing OData Queries against Mobile Services using Mobile Backend Tools

[Xiao-fei_Song]

In the previous blog post, we should already be able to access the OData services of the mobile destination using the combination of SAP Mobile Services Mobile Backend Tools and OData CSDL Modeler:

Now we will show you how to test the OData services by running OData queries using Mobile Backend Tools. 

First click "Run Test Query" toolbar button in the right top corner:

Now you should be able to see the test query page like below:

If you click the "Send" button, you will be able to see the service document of the backend OData services:

Now we can execute some OData query by specifying the OData query URLs, for example "PurchaseOrder?$filter=CreatedByUser eq 'CB9980000026' and PurchasingOrganization eq '1710' and Supplier eq '17300001' and PricingDocument eq '1000000340'"

Let's try some a bit more complex one like "PurchaseOrder?$filter=CreatedByUser eq 'CB9980000026' and PurchasingOrganization eq '1710' and Supplier eq '17300001' and PricingDocument eq '1000000340'&$expand=_PurchaseOrderItem,_PurchaseOrderNote":

And even more complex query like "PurchaseOrder?$filter=CreatedByUser eq 'CB9980000026' and PurchasingOrganization eq '1710' and Supplier eq '17300001' and PricingDocument eq '1000000340'&$expand=_PurchaseOrderItem($expand=_DeliveryAddress,_PurchaseOrderInvoicingPlan,_PurchaseOrderItemNote),_PurchaseOrderNote":

Like you can see, in the above scenarios the SAP Mobile Services Backend Tools will handle the complex authentication for you, and you just need to run your OData queries against the backend system through the mobile services destination inside the Visual Studio Code environment.