Helpful Scripts

Compendium of popular requests and use cases for the external API.

All the files import whitson_connect.py provided here to use a helper class WhitsonConnection which abstracts some of the API endpoint requests to use simple python functions in python script to manipulate, query data stored in our database for you.

1. Which wells are using 'Custom BHP' instead of a correlation for all calculations?

Objective: Fetch all the wells and scenarios in a list of projects and fetch their BHP input to see which wells are using the 'Custom BHP'. Generate an Excel file containing a list of these wells/scenarios and their owners.

Use Case: You can use external API to upload new production data daily, calculate bottomhole pressures fpr all the wells using the correlations but if the well uses "Custom BHP" (user-defined BHP) for all calculations, the added BHP data does not reflect in other plots because the custom BHP does not get extended to include the new BHP data automatically. Hence, we need to see which wells are using "Custom BHP" so this list of wells can directly be updated on the front end without having to check every well manually.