@djmolloyjr22

The REST api has a feature that allows bulk updating of data points via a PUT of a JSON array, but this has not been rigorously tested and is still in Beta. Use at your own risk since not every type of data point has been verified to work. I would suggest making a backup of your database prior to testing your specific updates.

Here is the basic idea:

Make a GET request to {YourMangoHost}/rest/v1/data-points to get all your data points as an Array in JSON format Edit your JSON Do a PUT request with the edited array of data points as the payload to {YourMangoHost}/rest/v1/data-points

Note that since the JSON structure for a Data Point in the REST API is different than the Mango JSON Export you cannot use one with the other.

One quick note:

In the latest nightly build of 2.6.0 we are removing the ability to add the .json to the end of the URLS for the REST api. This was done because we found we could not easily interpret dots in other areas of the URL. So for example:

/rest/v1/users/admin.json

must now be:

/ret/v1/users/admin

This better allows us to do things like:
/rest/v1/users/firstname.lastname

The other feature this effects is the ability to define the content type using a file extension on the URL. So for example previously one could request a csv file:

/rest/v1/data-points/data-source/DS_XID.csv

Or a JSON file:

/rest/v1/data-points/data-source/DS_XID.json

One must now use:
/rest/v1/data-points/data-source/DS_XID?format=csv
OR
/rest/v1/data-points/data-source/DS_XID?format=son
OR
Set the accept header in the request to the desired file type (CSV or JSON support only for now)

@jeremyh I'm swamped at work right but but will be happy to write up when I get a break, probably around 1July. Short story, we are a datacenter company and using the product as a backend data acquisition tool to provide energy and environmental (Critical and Essential) such as room temperature/humidity/air handler information. We have a various set of protocols ranging from ModBus, BacNet, SNMP, SQL, and custom SOAP calls and needed a one stop package that Mango provides. We have a front-end website that makes API calls to the Mango for data point retrieval.

@djmolloyjr22

I realized the "script" datasource would be sufficient. It would be cool to do some native SOAP calls, but this will get me through.

I've tested it on the 1.1.1 module that is about to be released with Mango 2.7.0 this week and it works fine with that version. You may have to wait as I'm not 100% sure when that feature was added.