Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to connect JSON data obtained from Google Sheets API with Data Connections

Tomokazu Yamada
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 5, 2024



I would like to make display Forms checklist items by accessing a simple database.

It shows item dynamically.

To achieve this, it is known that JSM's Data Connection function is used to obtain JSON data.

When creating JSON data, I tried accessing the data using the Google Sheets API, but I was unable to successfully retrieve the Excel values from the Data Connection page. (*See image)

Then, I checked the following page as a solution for this case, but I cannot implement the answer.


Is this because the version change ?

Is the reason I can't run it because it's the free version?
If I use the paid version, will I be able to run it?

We are currently testing the functionality and plan to use the paid version internally in the near future.


Thanks in advance.




0 answers

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events