SAP Automation - API/PowerShell

[brian862107]

Hi,

I'm new to API's but have been learning PowerShell. I heard it was possible through the use of API's to be able to update users in Bulk for SAP Hana or script. If anyone can help give guidance on where to start or has any examples of how to do the following that would be appreciated:-

• Update "Documentation", "Roles", or "DBMS" details and other details on SAP HANA by automation. If there is a way to do this by importing CSV and running script that would be great.
• Get information from SAP Business Object Central Management Console such as user ID and groups.
• Select "Update" Authentication in SAP Business Object Central Management Console for Active Directory (also same for SAP - update roles and aliases now).
• Update Kerberos and SAML details in SAP HANA Studio or different environments and updating data restrictions for a user.
• Is there a way to execute transactions in SAP Hana remotely?

Any guidance on documentation on how to do this or example of a script that would do any of that would be appreciated.

Thanks in Advance

[former_member191883]

Hello David,

I am not quite sure if understood your question correctly.

On SAP Business Accelerator Hub you can find RestAPIs for various products. So I suggest that you check if you can find a Rest API for your purpose here.

If you have found what you need you can run a CURL command in your power shell to execute the RestAPI.

hint: just put your questions to AI and it might guide you very well on how to create the Curl command out of the REST API specification for PowerShell