In a previous blog post, we covered some of the APIs in Tensoft SemiOps. Here is a list of Tensoft DemandOps APIs that you may find useful.
GetBookings. This is a listing of bookings by customer and sales order. Bookings is the net change in a sales order value. For example, you book an order for $1000 in January and then the customer makes a change request and adds another $1000 in February and then they cancel the whole order in March. In this case, the bookings would show an amount of $1000 in January, $1000 in February and – $2000 in March for that same sales order. So, it’s kind of like a change history by date for sales orders.
GetInvoices. This is a listing of invoices.
GetInvoiceShipmentDetails. This is similar to invoices except that it has got more detail for each line for shipment information that comes over from SemiOps.
ShippedAndBacklogs. This includes both shipments to date and what’s in backlog. It is a way to look at shipment history, what has been shipped to date and then what is on backlog to ship in the future. So, it’s a good way to trend out your revenue forecast for at least what’s on sales order.
GetSalesOrders. This is a listing of current snapshot of sales orders. Bookings is kind of change over time, but this is just real time backlog data.
GetBusinesses is a listing of customers.
GetParts is a listing of Parts items.
With DemandOps APIs, you can add filters and so you don’t have to pull the full value. For example, you can look at specific date range by adding a filter on your start date and end date.
If you prefer to create your own custom reports using the raw data in Tensoft SemiOps and DemandOps, you can connect to these APIs with Excel or Power BI. DemandOps is connected through a web source and so you must put in your unique company code into the URL. You need to know the company code for your test or live companies to specify from which company you want the URL to access the data.
After connecting, you can use the advanced functionality like merge or append in the power query editor to query things. View this helpful demo to learn more!