Skip to main content
sheldona0001
October 20, 2021
Question

Error Process Integration Response Error

  • October 20, 2021
  • 2 replies
  • 0 views

Good Day,

I have tested my URL link in Postman and it seems to work in there, however, when I create a record data through Web Services using HTTP with the same link and I test it in Appian where the 

Response Body Parsing is "Convert JSON to Appian Value" the test fails, also keep in mind I did select "Google Service Account" and uploaded the JSON file that I had received when creating my service account that is linked to the project that contains the data.

When I run the test when the Response Body Parsing is "Return raw response body" the test passes.

Is there a reason why the data from Big Query does not convert the JSON to Appian Value?

2 replies

peter.lewis
Employee
October 20, 2021

Can you post the raw response that you get from the service? What error message do you receive when you try to do the conversion?

sheldona0001
October 21, 2021

Good Day,

I managed to integrate BigQuery's data into Appian, the issue was the URL, it had an extra bit on the end which caused that issue when converting to JSON to Appian Value.