Idera AI Documentation Assistant

From version 8.9.7, SQL Dm for MySQL exposes a new ‘Get’API. This API aims to get information from the tool.

General ‘Get’ API

The endpoint for all ‘Get’ requests looks like:

$ curl "192.168.1.1:5555/?_object=MONyogAPI&_action=get&_details=<resource>&[optional Additional params]&_user=<sqldm user name>&_password=<sqldm user password>”
  • _action: It should be ‘get’.
  • _details: This value determines what data to fetch.

getlicenseinfo 

API to fetch license-related details:

$ curl "[IP]/?_object=MONyogAPI&_action=get&_details=getlicenseinfo&_user=<sqldm user name>&_password=<sqldm user password>”
  • _details=getlicenseinfo
  • The API returns:
    • RegName
    • Expiry date (time in seconds)
    • Current version
    • MaxServerLimit
  • If a non-admin users fetch the API, then the ExpiryDate and MaxServerLimit are returned.
  • Return format JSON.
  • For the trial build Regname is empty and no ExpiryDate and MaxServerLimit are sent.

Example 

$ curl"34.225.194.88:5555/?_object=MONyogAPI&_action=get&_details=getlicenseinfo&_user=admin"

- {"STATUS": "SUCCESS", "RESPONSE": "{ "Version": "8.9.7", "RegName": "Ankush" , "ExpiryDate":1868745599, "MaxServerLimit": 400 }"}
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels