Hi,
I've got a table with around 30,000+ rows in. The data is fixed but new rows could be added.
I need to produce an Excel table with the contents of this huge table in it - but the Excel is narrowed down to just 3 columns.
Rather than producing the entire excel report every day, is there anything I can put in the ODATA filter to get any rows which are NOT in an array (array being a list of unique keys from the existing excel table)
I'm using the action SQL Get Rows V2