How to POST request using tRESTClient?

[navnath]

I have created n job using input file component as a tFileInputJson having a JSON is

{

 "record":{

"options": {

"project_number": "Proj-000011",

"bpname": "Forecast"

},

"data": [

{

"record_no": "FC-00047",

"gen_month_tb": "09",

"gen_year_tb": "2020",

"status": "Active",

"BudgetInflated_ca": "433",

"gen_DirectIndirect01_PD": "34567",

"Indirect": "34567",

"creation_date": "10/15/2021 05:25 PM"

}

]

}

}

, which give me a response in the body in the following way

[{"BudgetInflated_ca":"433","record_no":"FC-00047","gen_month_tb":"09","Indirect":"34567","creation_date":"10\/15\/2021 05:25 PM","gen_DirectIndirect01_PD":"34567","gen_year_tb":"2020","status":"Active"}]|

|{"bpname":"Forecast","project_number":"Proj-000011"}  

I need to create a new record with this response using tRESTClient component. and pass this response as the body how to do that pls help me

thank yu

[Anonymous]

Hi @navnath kalhatkar​,

The error message suggests that the problem is with the fact that the "string" column required by the tRestClient is not populated. The easiest way to resolve this is to place a tMap between your tLogRow and your tRestClient. Then connect the column that holds your JSON to the "string" column of the tMap output that feeds your tRestClient.