Getting 400-bad request error, when post data via table rest api in powershell

[zhanglixin]

I try to post data from one PDI to another using powershell(the script is copyed from the rest api explore page). 

1.I try to get data from one instance, the data return correctly.

2.Then I edit the record in returned json and use as the body for the post method to post to another instance.

3.when I run the powershell script, it returns 400 error code.

4. However when I run the post method seperately. It runs OK.
I have confirmed the body data format is exactly the same.

Anyone knows why this happens???

[Amit Verma]

Hi @zhanglixin 

Can you please post your consolidated script here ? Also, please make use of PowerShell ISE while editing PowerShell scripts as other editors unnecessarily introduces some special characters which create problems afterwards,

Thanks & Regards

Amit Verma

[Amit Verma]

Hi @zhanglixin 

One more observation - You are converting the response received from a GET call to JSON. This is not required as the response is already in JSON. Request you to remove |Convertto-JSON and try once more.

Thanks & Regards

Amit Verma

[Ankur Bawiskar]

@zhanglixin 

something wrong with the request body

[zhanglixin]

Yes ,you are right. I missed to convert the string record to json. I corrected the script and post the answer. you can refer it if you are interested.