topic Re: REST API and Request Body type: Connection Error / JSON or XML in Connectivity & Data Prep

REST API and Request Body type: Connection Error / JSON or XML

bmalkowski — Fri, 09 Jul 2021 19:24:04 GMT

I am trying to make a successful connection with the REST API and am struggling with 2 items:

1) The vendor provided a test API site and has options for JSON or XML - which would I use in the request body?

2) When I test the connection I keep getting this connection error:

Thanks.

Re: REST API and Request Body type: Connection Error / JSON or XML

NadiaB — Fri, 09 Jul 2021 20:12:54 GMT

Hi @bmalkowski

It seems you are trying to create a REST connection? If so in the connection configurations there is a section "Query Headers" where you can add the necessary headers (example)

Name Value
Content-Type application/json

If that is not the case, could you provide the steps you follow to recreate the issue?

Kind Regards.

Re: REST API and Request Body type: Connection Error / JSON or XML

bmalkowski — Sun, 11 Jul 2021 20:28:38 GMT

Hello Nadia,

That is correct in that I am trying to create a REST connection.

I added the information in the Query Headers section and the connection was successful!

Now I need to figure out how to load many parts instead of one in the request body. I will likely have a 100's of parts in a spreadsheet that I need check attributes against.

Thanks again.