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 }"}