Skip to main content
Solved

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

  • July 6, 2023
  • 2 replies
  • 69 views

Forum|alt.badge.img

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
}

Best answer by jinin

Hi @ashrivastava42 ,

 

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

2 replies

jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • Answer
  • July 6, 2023

Hi @ashrivastava42 ,

 

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


Forum|alt.badge.img+2

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