Web Services Parent Endpoint id in Query Parameter

[ethompson (Edward Thompson)]

I am working with the Cornerstone reporting API and there are 2 endpoints I need to use.

/vw_rpt_user: user_id (account id), user_ref (correlation), first and last name
/vw_rpt_transcript: transc_user_id (account id), entitlement id

I am able to aggregate and pull users from the user endpoint, but I need to use the “user_id” (account id) field to then make a child endpoint call on transcript to get all of the entitlements that user has. In postman, I can use a query parameter similar to

/vw_rpt_transcript?$filter=transc_user_id eq $response.user_id$

For example:

/vw_rpt_transcript?$filter=transc_user_id eq 1234

On the Aggregation WS Doc, it shows using the $response.attribute$ syntax in the body, but I need to use it in the Query Params. Is there a way to call the second endpoint with a query param variable from the parent endpoint?

https://documentation.sailpoint.com/connectors/webservices/help/integrating_webservices/json_aggregation.html

Current Error during aggregation:

[adunker (Alex Dunker)]

I believe you would be best served with a Before Operation Rule and leveraging the oldResponseMap. You can then use the setters to add your ID in the query parameters.

IdentityNow Rule Guide - Web Services Before Operation Rule - Compass (sailpoint.com)

[sharvari (Sharvari Bharatiya)]

In your Context URL replace the space characters before and after eq with %20 and retry the operation.