Thursday, March 9, 2023

ODATA Filters


ODATA Filters.


GET :

URL/data/CustomersV3?$filter=CustAccount eq '56'&dataAreaId eq 'DAT'&cross-company=true
URL/data/CustomersV3?cross-company=true


Patch or PUT:

URL/data/CustomersV3(dataAreaId='DAT',CustomerAccount='77')?Cross-company=true



Using Enums:

Microsoft.Dynamics.DataEntities.Gender'Male'

Microsoft.Dynamics.DataEntities.NoYes'Yes'

            Using in filter: 

        1. URL/CustomersV3?\$filter=PersonGender eq Microsoft.Dynamics.DataEntities.Gender'Male'
       2. URL/CustomersV3?$filter=PersonGender eq Microsoft.Dynamics.DataEntities.Gender'Male'
        URL/data/Currencies?\$filter=ReferenceCurrencyForTriangulation eq Microsoft.Dynamics.DataEntities.NoYes'No'

            Using to update:

        URL/data/CustomersV3(dataAreaId='usmf',CustomerAccount='1001', 
                                PersonGender= Microsoft.Dynamics.DataEntities.Gender'Male')?Cross-company=true


Keep Daxing!! 

No comments:

Post a Comment