I am using the following convention to query a data sheet:
currently, this URL filters and looks for exact project name match,
is there a way i can modify the URL so it will look for all projects the contain the given PROJECT_NAME?
Create a parameter called PROJECT_FILTER and pass that in your URL instead of PROJECT_NAME, after setting up a filter on PROJECT_NAME that references the PROJECT_FILTER. Here's an example using Superstore data.
Retrieving data ...