Dynamics Community Forum Thread Details

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

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,

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

Quick Links