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?
Discussion posts and replies are publicly visible
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?
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.