Skip to Content
0
Jan 27, 2018 at 03:39 AM

Rest Receiver Adapter - XML to JSON issue - HTTP error occurred: Unprocessable Entity

1115 Views

Hi Team,

My Scenario is Proxy to Rest and I am facing issue in converting XML to JSON format Error is : HTTP error occurred: Unprocessable Entity, Below is the target structure

Target Structure

Adapter Screenshot

I am getting this additional node "Data" in the output, how do I remove it

{"Data":[{"FinancialTransactionKey":311,"CompanyCode":"US9V","StatusCode":"ERR"},
{"FinancialTransactionKey":769,"CompanyCode":"US9V","DocumentNumber":"6778","FiscalYear":2018,"StatusCode":"COM"},
{"FinancialTransactionKey":123,"CompanyCode":"test1","DocumentNumber":"123","FiscalYear":2018,"StatusCode":"COM"},
{"FinancialTransactionKey":1234,"CompanyCode":"test2","DocumentNumber":"456","FiscalYear":2018,"StatusCode":"COM"},
{"FinancialTransactionKey":6879,"CompanyCode":"test3","DocumentNumber":"780","FiscalYear":2018,"StatusCode":"COM"}]}

Expected Output is

[{"FinancialTransactionKey":311,"CompanyCode":"888","StatusCode":"ERR"},
{"FinancialTransactionKey":769,"CompanyCode":"666","DocumentNumber":"6778","FiscalYear":2018,"StatusCode":"COM"},
{"FinancialTransactionKey":123,"CompanyCode":"test1","DocumentNumber":"123","FiscalYear":2018,"StatusCode":"COM"},
{"FinancialTransactionKey":1234,"CompanyCode":"test2","DocumentNumber":"456","FiscalYear":2018,"StatusCode":"COM"},
{"FinancialTransactionKey":6879,"CompanyCode":"test3","DocumentNumber":"780","FiscalYear":2018,"StatusCode":"COM"}]

Attachments

structure.jpg (33.9 kB)
rest-adapter.jpg (98.6 kB)