Solved

When use Web Service Endpoint have feature to transformation Json data format

  • 6 July 2023
  • 2 replies
  • 48 views

in Acumatica I am exposing data of purchases order by Web service endpoint but json data is not in expected format as required, do acumatica have feature to transformation Json data format.

Acumatica json format:

{ "id": "81f542f0-42d5-ed11-9272-00155d056707", "rowNumber": 1, "note": { "value": "" }, "warehouseCode": { "value": "01" }, "type": { "value": "PO" }, "supplyNo": { "value": "123" }, "lineID": { "value": "1" }, "custom": {}, "_links": { "self": "/AcumaticaSmartFactory/entity/ewsfendpoint/22.200.001/PurchaseOrder/81f542f0-42d5-ed11-9272-00155d056707", "files:put": "/AcumaticaSmartFactory/entity/ewsfendpoint/22.200.001/files/PX.Objects.PO.POOrderEntry/Document/81f542f0-42d5-ed11-9272-00155d056707/{filename}" } }

Required json format:

    {
"warehouseCode": "01",
"type": "Purchase Order",
"supplyNo": "123",
"lineID": 0
}
icon

Best answer by jinin 6 July 2023, 09:42

View original

2 replies

Userlevel 7
Badge +11

Hi @ashrivastava42 ,

 

Based on my knowledge, Acumatica does not have a feature to transform JSON data format.

Userlevel 4
Badge

Hi @ashrivastava42 

 

If you are not interested in creating some kind of middleware, the only other option I’m aware of would be Acumatica’s Webhooks functionality.  This would allow you to send data to Acumatica in a format that Acumatica does not natively support.  The downside is that you would need create a customization in Acumatica to process the requests entirely in code.

 

If you are interested in Webhooks, here is some documentation:

https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=5c7c820a-7b48-44b0-87da-88b83a4608e6

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved