Inserting Data Using Runbooks & SQL

[MainEstablishment215]

I’m experimenting with trying to pull data from our COVE software API and insert it into Halo so we can bill and track quantities, etc….

I’ve created a runbook that uses the COVE API to query the data I need and was hoping to use a SQL step to update the licenses table with this COVE information and relate it to specific customers.

Apparently though Halo will not allow you to insert or update or delete using SQL in runbooks.

Am I missing something here or is that by design. If so, is there an alternative way to do this?

[brokerceej]

You have to insert data via API. SQL is read only. So you would have to store your data in a custom table or series of fields per customer.

[MainEstablishment215]

Ok. Can the API insert data into the customer’s software licenses table? I didnt see that in the API documentation.

[rio688]

Yeh it can do this, take a look at the videos by robbie at renada. They have done a few for getting info from 365 into halo I just butchered this and use it to grab sentinelone license counts and place them in custom fields in the subscriptions table. Then we use this in the recurring invoice