Does anyone know if it's possible to pre-filter the response returned by the XML feed (i.e., filtering on the server side), rather than returning ALL of the records in the selected view and being forced to filter on the client side?
I have tried the following technique but gotten very mixed results, attaching to the end of the XML URL ("&metaData.isheetExportType=xml") the same parameters that are added when running an advanced search from the site. For ex:
...&advanceSearch=true&filterValue_{COL_NUM}_1={URL_ENCODED_VALUE}
I have tried this both in the browser's url field and when making an ajax call on the client side. Often, the first time I make this call it works, but then the next time it returns the same results as the first call, even if I am using a different filter value. Sometimes the initial call does not filter at all or filters on the wrong value. It appears that something is cached, but given that the url parameters are changing, I don't know why that would be. And when trying from the browser's url field, I get different results in Chrome and Edge?
Is this technique possible but more is required to make it work or is there an alternative?