So i have onboarded payer sites as a delimited source in ISC for access review. So is there a way to automate just aggregation part so we can drop updated csv file and that delimited source pick up the file from that path and ran the aggregation. Can we do it in ISC itself or required any backend coding in VS Code. Please help me as i have onboarded the 100+ delimited sources. So this year i need to run the aggregation for each source again manually.
Hello @jalad10 ,
ISC doesn’t have a built‑in scheduler or “auto‑pickup” mechanism for delimited sources, so it can’t automatically re‑aggregate a CSV just because a new file was dropped into a folder. Delimited sources only aggregate when you manually trigger it or when an external process calls the API.
If you want this to run automatically, you’ll need a small backend process (PowerShell, Python, Azure Function, etc.) that:
-
Drops or updates the CSV file in the correct location
-
Calls the /sources/{id}/aggregate API endpoint for each delimited source
Since you have 100+ delimited sources, most teams automate this with a script that loops through all source IDs and triggers aggregation in sequence
Thanks
Siva
Hi @jalad10 ,
Hope this is what you’re looking for
Hi @jalad10 ,
As @SivaLankapalli Mentioned there is no default function provided by SailPoint, you can achieve this by using API - import-accounts | SailPoint Developer Community
Store File in shared location , Extracts sourceId (configurable regex), Calls POST {base}/v2024/sources/{sourceId}/load-accounts, Archives processed files, Logs to a rolling text log by.
Thanks,
Mahesh
There is no OOTB functionality that automatically does the aggregation for delimited file. You can use the SailPoint ISC Api to trigger the aggregation with the latest file and automate it.