I managed to create a connection to BigQuery's API, however, How would one go about pulling and pushing data between BigQuery and Appian?
Discussion posts and replies are publicly visible
Appian has great integration tools for exactly the use cases of pushing or pulling data. These docs should help
docs.appian.com/.../methods_of_integrations.html
Thank you for that, I will look into the documentation. Just to get an idea, what I am trying to achieve. I managed to get a database I have in BigQuery into Appian and the data is showing in Appian's format. The pushing part. would that allow any data changes made or updated in Appian to be processed back into BigQuery's side as well?
Sure, an integration object works for both pushing and pulling. Usually if you want to push changes you would create an integration that uses POST to update data in your external system. The integration designer itself lets you test out updating data directly, and then you can use the integration elsewhere in your application (for example within a process model).