Goggle Sheets Get Request Error

Need help APIs
1

I am attempting to get data from Google Sheets based on user input

The user types a string in 2 input boxes the site returns the corresponding data

I have:

  1. Create a Google Sheet with headers and data
  2. Used Sheety to turn my Sheet into an API endpoint
  3. Installed the API Connector Plugin
  4. Initialised a GET request
  5. Created a reoccurring group
  6. Added text to the reoccurring group
  7. Configured the reoccurring group data source and type of content
  8. Configured the text to insert dynamic data

Problems

  1. The input and the reoccurring group is not connected
  2. I want to limit the results to only results that exactly match the input

Desired result
I only want to return 1 result that exactly matches the input

Current result
All the API data returns on page load

Additional information
Link: https://cipherly.bubbleapps.io/version-test?debug_mode=true
There is no API authentication
API Example 1
https://api.sheety.co/32e1c813ca6e94c9e162ae97db4278d7/cipherly/sheet1
API Example 2
https://api.sheety.co/32e1c813ca6e94c9e162ae97db4278d7/cipherly/sheet1?filter[encodedMessage]=This+is+an+encoded+message&filter[password]=nocode2020

What steps can I take to achieve the desired result?

2

HI,

Have you found a solution for this?