Quick guide: mWater CSV data via API call

You can programmatically bring data from mWater to another system in just a few steps by creating a datagrid and using the API command that is generated when downloading that datagrid. Here we cover the steps on how to get that API call, and how to use it in PowerBI and Google Sheets to bring through real-time data.

1) Create a Datagrid with your chosen columns and filters

3) Take the URL which appears in the browser when you've clicked the download as CSV link referencing api.mwater.co

4) This is a fully formed API call you can use to integrate with other systems such as PowerBI

The URL does not appear in the URL bar for very long. You can build this API call yourself with a few further steps. In a nutshell, use the browser developer tools to get the request URL and add download to the URL after the datagrid ID and before the client ID

https://api.mwater.co/v3/datagrids/fa502b6cc4dd445cb145d8d8de8488ea/download?client=[client ID]&share

function importCSVFrommWater() {
    const url = 'YOUR_API_URL_HERE'; // Replace with your mWater API URL
    const response = UrlFetchApp.fetch(url);
    const csvData = Utilities.parseCsv(response.getContentText());
    const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    sheet.clear(); // Clear existing data
    sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}

NOTE: Your Client ID is like your password. Treat it with the same caution! The client IDs used above are fake.

For more dynamic imports, refer to api.mwater.co