Mac OS (Microsoft Excel)

The SAP S/4HANA Cloud connector has the following respective fields in the UI:

  • For IdentityIQ Role Details file path enter the CSV file path

  1. Sign in to the S/4HANA Cloud tenant, and execute the following query to export results in the JSON format:

    https://<hostname>/sap/opu/odata/sap/APS_IAM_BRT_SRV/aps_iam_brt_br?sap-client=100&$format=json&$sel...

    Note
    You can add more fields to the above URL, separated by commas, to get the dates. Available fields are UUID, TemplateID, LongText, Description, ID, ChangedOn, DifferFromTemplate, and BusinessCatalogAssignmentCount.

  2. Open Microsoft excel for Mac (License: Office 356 Subscription/ Version 16.32).

  3. In the Excel menu, go to Insert > Add-ins > Get Add-ins.

  4. Search for the JSON to Excel add-in, and select Add.

  5. Select the JSON to CSV icon, and copy the API response JSON. Paste it into the Paste your JSON here field.

  6. Select Convert to see the data loaded in the sheet.

  7. Delete the first three columns and rename the UUID column to Business Role UUID, and rename the ID column to Business Role ID.

  8. Go to File > Save As and save the file in .csv format.