# Full Aggregation API Not Working in Workflows **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** workflows, sailpoint-identity-security, aggregation, apis\ **Created:** [March 11, 2025, 3:44am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730 "2025-03-11T03:44:20Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![sst11](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@sst11](https://developer.sailpoint.com/discuss/u/sst11)\ **Post date:** [March 11, 2025, 3:44am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/1 "2025-03-11T03:44:20Z")
Hi all, I have created one workflow to run the BETA\load-accounts API (for aggregation) on scheduled. Below are the details: Authentication: OAuth 2.0 Token URL: [https://TENANT.api.identitynow.com/oauth/token](https://TENANT.api.identitynow.com/oauth/token) request URL: [https://TENANT.api.identitynow.com/beta/sources/SOURCEID/load-accounts](https://TENANT.api.identitynow.com/beta/sources/SOURCEID/load-accounts) Content-Type: multipart/form-data Method: POST Request body: disableOptimization : true But when I test workflow to run, the workflow keep running at the HTTP action item and will not finish: ![image](https://global.discourse-cdn.com/sailpoint/original/3X/a/e/ae8041151195e550eb0b8ecc4f95e1b4df301f13.png) There is no error return, but the workflow will not end and there is no aggregation triggered at the source. I tried to run on POSTMAN and there is no issue. I tried to use same client ID and secret to run other BETA POST API also no issue. Please kindly advise on this. ---
**Author:** ![rkhade](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/rkhade/32/6043_2.png) [@rkhade](https://developer.sailpoint.com/discuss/u/rkhade)\ **Post date:** [March 11, 2025, 6:17am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/2 "2025-03-11T06:17:53Z")
Hi @sst11 , have you checked execution logs, if yes, what are the details you are getting are you able to see ActivityTask details or HTTP Request step in the execution ? ---
**Author:** ![sst11](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@sst11](https://developer.sailpoint.com/discuss/u/sst11)\ **Post date:** [March 17, 2025, 1:49am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/3 "2025-03-17T01:49:26Z")
Hi Rakesh, Yes I have checked the execution log, it shows me 500 error code. ---
**Author:** ![kdfreeman](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/kdfreeman/32/22737_2.png) [@kdfreeman](https://developer.sailpoint.com/discuss/u/kdfreeman)\ **Post date:** [March 17, 2025, 3:32am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/4 "2025-03-17T03:32:12Z")
Are you tokenizing SOURCEID with `{{SOURCEID}}` ? If any variables are involved, you need to enclose those variables in ` {{ }}`. ---
**Author:** ![sst11](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@sst11](https://developer.sailpoint.com/discuss/u/sst11)\ **Post date:** [March 17, 2025, 3:55am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/5 "2025-03-17T03:55:35Z")
Hi Kapil, No, I actually enter the real source ID in the URL instead of tokenizing it. It is something like this: ([https://tenant.api.identitynow.com/beta/sources/123456789/load-accounts](https://tenant.api.identitynow.com/beta/sources/123456789/load-accounts)) ---
**Author:** ![kdfreeman](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/kdfreeman/32/22737_2.png) [@kdfreeman](https://developer.sailpoint.com/discuss/u/kdfreeman)\ **Post date:** [March 17, 2025, 4:57am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/6 "2025-03-17T04:57:22Z")
What is your source Type? It is not possible if it is delimited. Also, did you add `Content-Type: multipart/form-data` in header inside workflow HTTP Action? ---
**Author:** ![sst11](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@sst11](https://developer.sailpoint.com/discuss/u/sst11)\ **Post date:** [March 17, 2025, 9:45am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/7 "2025-03-17T09:45:19Z")
Hi Kapil, My source type is SQL Loader, and yes I added the Content-Type: multipart/form-data in the header section as well. ---
**Author:** ![schattopadhy](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/schattopadhy/32/8854_2.png) [@schattopadhy](https://developer.sailpoint.com/discuss/u/schattopadhy)\ **Post date:** [March 17, 2025, 11:59am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/8 "2025-03-17T11:59:51Z")
> [@sst11](#): > > e client ID and secret to run other BETA POST API also no issue. > > Please kindly advise on this. @sst11 can you try the v 2024 api. also when you tried from postman did you try from postman browser one or on premise one ? ---
**Author:** ![sst11](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@sst11](https://developer.sailpoint.com/discuss/u/sst11)\ **Post date:** [March 20, 2025, 3:08am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/9 "2025-03-20T03:08:45Z")
Hi Shantanu, I have tried v2024 api, but it will result to Request Failed when I run test workflow. I tried from postman on prem, not browser one. Thanks! ---
**Author:** ![Tulasi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/tulasi/32/34596_2.png) [@Tulasi](https://developer.sailpoint.com/discuss/u/Tulasi)\ **Post date:** [March 20, 2025, 7:40am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/10 "2025-03-20T07:40:09Z")
Hi Shuen, Have u kept the request content type as the form ![image](https://global.discourse-cdn.com/sailpoint/original/3X/d/b/dbfcc57c58bca44048f1ac829e96786583728e9a.png) ---
**Author:** ![sst11](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@sst11](https://developer.sailpoint.com/discuss/u/sst11)\ **Post date:** [March 20, 2025, 8:02am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/11 "2025-03-20T08:02:42Z")
Hi Tulasi, Yes, I have set it to Form. ![image](https://global.discourse-cdn.com/sailpoint/original/3X/7/f/7f846ce9dc3f44ea74f0331d3156eeb0bec87d7a.png) ![image](https://global.discourse-cdn.com/sailpoint/original/3X/1/c/1c22ea150bc1cb4b763e06da75641b87afe5189a.png) ![image](https://global.discourse-cdn.com/sailpoint/original/3X/0/0/0066f17d45d89f20bf00cf39800cfadff7056f0a.png) ![image](https://global.discourse-cdn.com/sailpoint/original/3X/d/5/d55862e01778b70dd11bfff566795b06320f99ba.png) ---
**Author:** ![sst11](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@sst11](https://developer.sailpoint.com/discuss/u/sst11)\ **Post date:** [March 20, 2025, 8:29am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/12 "2025-03-20T08:29:43Z")
Hi all, I have figured out the way - it is because the client ID and secret I used is the API I created from the API Management in the tenant. But according to the another post - [Using Workflow's HTTP Request Action to Work With IdentityNow APIs - #6 by colin\_mckibben](https://developer.sailpoint.com/discuss/t/using-workflows-http-request-action-to-work-with-identitynow-apis/7207/6) We must use PAT to call the API. Once I changed to my PAT in the workflow and now the workflow can run without issue. Thank you everyone for the kind assistance! ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [May 19, 2025, 8:30am UTC](https://developer.sailpoint.com/discuss/t/full-aggregation-api-not-working-in-workflows/103730/13 "2025-05-19T08:30:25Z")
Closed on May 19, 2025, 8:30am UTC This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.