Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Taking a different approach, this example works for copying the value. So it should get me what I need, but I'd still like to know if there is a way to get the count of rows for a given variable or named range if possible. In this example my timestamp is the first column, and epoch is the second column. I have headers above the named ranges, so it starts at row 1. This also assumes that the 'Date__EPOCH' range is empty when post processing starts. ExcelReportUtility.openNamedRange('Date__EPOCH', false); var timestamp = null; var i = 1; do { timestamp = ExcelReportUtility.getString(0, 0, i); if (timestamp == null) { break; } ExcelReportUtility.writeStringToNamedRange('Date__EPOCH', timestamp); i += 1; }while (timestamp != null);

Awesome! They are not HTTP payloads. I use let's encrypt and certbot to handle certificate renewals. There is a script in mango that can be run after the cert is renewed that will move the certificate into the keystore and replace the old cert. /mango/bin/certbot-deploy.sh You may want to look at that.

@zaaphod said in JSON RETRIEVER: Error 400: {"slot":0,"io":{"di":[ {"diIndex":0,"diMode":0,"diStatus":0}, {"diIndex":1,"diMode":0,"diStatus":0}, {"diIndex":2,"diMode":0,"diStatus":0}, {"diIndex":3,"diMode":0,"diStatus":0} ]}} You're already 90% of the way there. I'd argue your code will be something like this since there is no "result" property in your incoming data. var data = JSON.parse(content); data = data.io.di; //lets get the info we want. However, you still need to be able to have a means to link what diIndex is what point. If you have the points configured with a specific XID or naming convention, we can use that to map it all together. Fox

Cripes Id love to but we are talking five thousand plus points here. Thanks so much for digging deeper

Hii You can also use https://onlinejsontools.org/ for json validator,beautify,minify,xml,yaml,CSV,bson,plain text,base64,tsv. Do checkout this site!

@craigweb Thanks Craig for your help, it worked :-)

I believe since 3.6 the default was changed from 200 to 100. This has always been the case. I always write a full rql string to ensure nothing is amiss. I think you've found a typo. Fox

No worries, much appreciated. =)

@cwangv I'd argue this isn't much of an issue rather than being a means to display watchlist values. Exactly..

Ah ok, thank you guys. This helps quite a bit. I am currently using the free license at the moment to investigate whether or not Mango is the right for our project. So far it seems really great and I'm glad there is a solution for my duplicates problem. I appreciate all the help here in the forums.