Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Is there a tool to easly see what is returned by Odata ?

(0) ShareShare
ReportReport
Posted on by 516
Hi,
 
When we browse OData in URL, we will get this kind of display :
 
{  /@odata.context/:https://qqqqq.sandbox.operations.dynamics.com/data/$metadata#ReleasedProductsV2/,/value/:[    {      /@odata.etag/:/W////JzUwNjg5Nzk3MSw1NjM3MTQ0NTk4OzAsMDsxLDU2MzcxNDQ1OTg7MSw1NjM3MTQ0NTc3OzEsNTYzNzE0NDU3NzsxLDU2MzcxNDQ1Nzc7MSw1NjM3MTQ0NTc3OzE2MzMxNTE5MDMsNTYzNzE0NDY0MjsxMTMyMjk3NzUsNTYzNzE0NDY0NDsxNDA4NDU2NjMyLDU2MzcxNDQ2NDM7MCwwOzAsMDswLDA7MCwwOzEsNTYzNzE0NDU5ODsxLDU2MzcxNDQ1OTg7MCwwOzAsMDswLDAn////,/dataAreaId/:/sfa/,/ItemNumber/:/CE-EXSA Tee/,/IsPhantom/:/No/,/IsPurchasePriceIncludingCharges/:/No/,/ItemFiscalClassificationCode/://,/SeventhProductFilterCode/://,/ServiceAccountingCode/://,/MarginABCCode/:/None/,/IsICMSTaxAppliedOnService/:/No/,/ShippingAndReceivingSortOrderCode/:0,/ProductionConsumptionWidthConversionFactor/:0,/AlternativeProductSizeId/://,/CatchWeightItemHandlingPolicyName/://,/RawMaterialPickingPrinciple/:/Staging/,/WarehouseFilterCode/://,/ProductionConsumptionDepthConversionFactor/:0,/DefaultProductConfigurationId/://,/ItemModelGroupId/:/TRACK STOCKS/,/GrossProductHeight/:0,/AlternativeProductVersionId/://,/IsSalesWithholdingTaxCalculated/:/No/,/ScaleIndicator/:/Relevant/,/ProductVolume/:0,/TrackingDimensionGroupName/:/NONE/,/PurchaseSalesTaxItemGroupCode/:/NA/,/CustomsExportTariffCode/://,/UpdateProductVariantLifecycleState/:/No/,/PlanningFormulaItemNumber/://,/WarehouseMobileDeviceDescriptionLine1/://,/InventoryCountingReasonCodePolicyName/://,/WarehouseMobileDeviceDescriptionLine2/://,/SalesItemWithholdingTaxGroupCode/://,/IsUnitCostProductVariantSpecific/:/No/,/IsHazardousMaterial/:/No/,/IsPOSRegistrationQuantityNegative/:/No/,/UpperWarrantablePriceRangeLimit/:0,/POSRegistrationPlannedBlockedDate/:/1900-01-01T12:00:00Z/,/SellEndDate/:/1900-01-01T12:00:00Z/,/SADGroup/://,/IsPurchaseWithholdingTaxCalculated/:/No/,/DefaultLedgerDimensionDisplayValue/://,/WarrantyDurationTimeUnit/:/Day/,/CommissionProductGroupId/://,/IsExemptFromAutomaticNotificationAndCancellation/:/No/,/TaxSubstitutionCode/://,/ProductionType/:/BOM/,/NetProductWeight/:0,/ProductionPoolId/://,/SalesSupplementaryProductProductGroupId/://,/WarrantablePriceRangeBaseType/:/None/,/StorageDimensionGroupName/:/SW/,/PurchasePricingPrecision/:0,/BOMUnitSymbol/:/ea/,/SalesPriceCalculationContributionRatio/:0,/CatchWeightUnitSymbol/://,/VendorInvoiceLineMatchingPolicy/:/NotSet/
}
 
Is there a tool to make this can be display nicely, like in grid or table ?
 
Thanks,
 
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Is there a tool to easly see what is returned by Odata ?
    Hi,
    Depending on the problem you described, it seems that you can view the data returned by OData according to the following methods:
    • Browser plugins: You can use browser plugins to view the data returned by OData. Some commonly used browser plugins include Postman, Advanced REST client, etc. These plugins allow you to send OData requests and view the returned data, including the URL of the request, headers, and the results of the response.
    • Fiddler: Fiddler is a popular web debugging and packet capturing tool that can be used to inspect and analyze OData requests and responses. With Fiddler, you can view detailed information about the requests, including the URL, headers, and body, as well as the responses returned from the server.
    • OData debuggers: Some development tools and integrated development environments (IDEs) provide built-in OData debugging capabilities. For example, Visual Studio has a tool called OData Service Explorer, which allows you to view and debug OData services and view the data returned.
    Best regards,
    Kevin
  • Suggested answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    Is there a tool to easly see what is returned by Odata ?
    Hi Ken,
     
    You can refer to the below blog and see if it helps.
     
    Thanks,
    Girish S.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans