I tried the .csv import method. that works, but I would like for the process to be as dynamic as possible because the list of system records in the external database changes daily. I want to import the new records into an organizational group and have a job to run against that group on a schedule.
When I created the data source and query in - Settings>All Settings>Notification Server>Connector - and did a test run to view the records, they are all there.
Then I tried to create an import filter rule, with the intention of importing the records into a filter in -Filters>Imported Filters- and build an organizational group off of the filter. Each record was imported as a separate filter. I need all the records to be in a single filter..
I hope all that makes sense. Let me know if you can assist further. thanks.