This forum uses cookies

gjniewenhuijse · 20.10.2020, 14:46

Hello,

Please, can anyone help with connecting a Ondilo spa monitor.

Authentication is to difficult for me Wink

Here the api info how to auth: https://interop.ondilo.com/docs/api/cust...entication
And here's the general api info: https://interop.ondilo.com/docs/api/customer/v1/

I have a app username and password but i see nothing in the doc how to get access to the api with that user&pwd

gjniewenhuijse · (This post was last modified: 21.10.2020, 18:29 by gjniewenhuijse.)

Ok, i give it a try

my code:

Code:
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
localusr = "my@email.com"localpwd = "mypwd"localuri = "https%3A%2F%2Fyour.app.url%2Fauthorize"-- there's no url redirect, so how to handle thislocalstate = "c7d37ee542c7'"-- random---------------------------- change nothing after this line -------------------------------localapiHost = "https://interop.ondilo.com"localapiUrl = apiHost .. "/api/customer/v1"localendpointToken = "/oauth2/token"localendpointAuth = "/oauth2/authorize"-- initifnotinitthenrequire('socket.http')
  require('ltn12')
  require('json')
  socket.http.TIMEOUT = 5init = trueendfunctiongetAuth()
  url = apiHost..endpointAuth..'?client_id=customer_api&response_type=code&redirect_uri='..uri..'&scope=api&state='..statemethod = "POST"localresponse_body = { }  
  localpayload = '{"login":"'..usr..'","password":"'..pwd..'","locale":"nl","proceed":"Authorize"}'localres, code, response_headers, status = socket.http.request
  {
    url = url,
    method = method,
    headers =
    {
      ["Accept"] = "application/json",
      ["Accept-Charset"] = "utf-8",
      ["Accept-Encoding"] = "gzip-deflate",
      ["Content-Type"] = "application/json",
      ["Content-Length"] = payload:len()
    },
    source = ltn12.source.string(payload),
    sink = ltn12.sink.table(response_body)
  }
  log(res, code, response_headers, status)
  log(response_body)
endgetAuth()

My return:

Code:
1234567891011121314151617181920212223242526272829303132
* arg: 1
  * number: 1
* arg: 2
  * number: 200
* arg: 3
  * table:
   ["server"]
    * string: Apache/2.4.29 (Ubuntu)
   ["content-type"]
    * string: text/html;charset=UTF-8
   ["connection"]
    * string: close
   ["access-control-allow-methods"]
    * string: GET, POST, PUT, PATCH, DELETE, OPTIONS
   ["access-control-allow-headers"]
    * string: X-Requested-With, Content-Type, Accept, Origin, Authorization
   ["cache-control"]
    * string: no-store, no-cache, must-revalidate, max-age=0, post-check=0, pre-check=0
   ["pragma"]
    * string: no-cache
   ["content-length"]
    * string: 4047
   ["date"]
    * string: Wed, 21Oct202017:45:44GMT
   ["vary"]
    * string: Accept-Encoding
   ["access-control-allow-origin"]
    * string: 
   ["access-control-allow-credentials"]
    * string: true
* arg: 4
  * string: HTTP/1.1200OK

but how to get the code that is normally send to the url given in the var uri (see above) or is my code wrong?

documentation is here: https://interop.ondilo.com/docs/api/cust...entication

if i do the same in a browser, my return url looks like:
https://your.app.url/authorize?code=6440...a88c&state=c7d37ee542c7

***admin*** · 22.10.2020, 06:30

What do you get in response body? You should also remove Accept-Encoding header otherwise body will be compressed with gzip instead of plain text.

gjniewenhuijse · 22.10.2020, 07:06

(22.10.2020, 06:30)admin Wrote: What do you get in response body? You should also remove Accept-Encoding header otherwise body will be compressed with gzip instead of plain text.

I see the plain website, i think the form is not filled and executed. But how to do this.
same source as:
https://interop.ondilo.com/oauth2/author...d44ef532c5

Code:
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
* table:
 [1]
  * string: 
<!DOCTYPEhtml>
<html>
    <head>
        <metacharset="utf-8"/>
        <title>Ondiloauthorizationpage</title>
        <style>
            * {
                margin: 10px4px10px4px;
            }
            .box {
                width: 340px;
                margin: auto;
                border: 1pxsolidrgb(41, 165, 155);
            }
            .banner {
                margin: 0px;
                background-color: rgb(41, 165, 155);
                height: 50px;
                position: relative;
            }
            .ico {
                position: absolute;
                top: 3px;
                left: 4px;
            }
            .ondilo {
                position: absolute;
                top: -1px;
                right: 4px;
            }
            strong {
                margin: 0px;
            }
            label {
                margin-top: 8px;
                margin-bottom: 0px;
                display: block;
                font-size: 0.8em;
                color: gray;
            }
            input, select {
                font-size: 1.2em;
            }
            input[type=text], input[type=password], select {
                width: 312px;
            }
            input[type=submit] {
                width: 322px;
                display: block;
                margin-bottom: 25px;
            }
            .authorize {
                color: white;
                background-color: rgb(41, 165, 155);
                margin-bottom: 10px;
                margin-top: 25px;
                border-color: rgb(41, 165, 155);
            }
            p {
                text-align: center;
                margin-top: 25px;
                margin-bottom: 25px;
            }
            .warningp, .warningul {
                margin: 0000;
                line-height: 15px;
            }
        </style>
    </head>
    <body>
        <divclass="box">
            <divclass="banner">
                <imgsrc="/images/ico.png"alt="ICO"title="ICO"class="ico"/
 [2]
  * string: >
                <imgsrc="/images/ondilo.png"alt="Ondilo"title="Ondilo"class="ondilo"/>
            </div>
                        <formmethod="post">
                <p>Signintoallow <strong>customer_api</strong> toconnecttoyour <strong>Ondilo</strong> accountandaccesstherelateddata</p>
                <labelfor="login">Youremailaddress</label><inputtype="text"name="login" ><br/>
                <labelfor="pasword">Yourpassword</label><inputtype="password"name="password">
                <labelfor="locale">Yourlanguage</label><selectid="locale"name="locale">
                    <optionvalue="en">English</option>
                    <optionvalue="fr">Français</option>
                    <optionvalue="es">Español</option>
                    <optionvalue="de">Deutsch</option>
                    <optionvalue="pt">Português</option>
                    <optionvalue="nl">Nederlands</option>
                    <optionvalue="it">Italiano</option>
                    <optionvalue="cs">Čeština</option>
                    <optionvalue="hu">Magyar</option>
                    <optionvalue="sv">Svenska</option>
                    <optionvalue="ro">Română</option>
                </select>
                <divclass="warning">
                    <p>
                        WeremindthatICOtakesmeasureseveryhour.</br>
                        Inordertoavoidexcessiveloadofourservers, therequeststotheOndiloCustomerAPIarelimitedtothefollowingperuserquotas :
                        <ul>
                            <li>5requestspersecond</li>
                            <li>30requestsperhour</li>
                        </ul>
                    </p>                
                </div>
                <inputtype="submit"name="proceed"value="Authorize"class="authorize">
                <inputtype="submit"name="proceed"value="Cancel">
            </form>
        </div>
    </body>
</html>

***admin*** · 22.10.2020, 07:14

For auth you need to use standard POST, not JSON:

Code:
1234567891011121314151617
functionencodepost(t)
  localres = {}
  localesc = require('socket.url').escapefork, vinpairs(t) dores[ #res + 1 ] = esc(k) .. '=' .. esc(v)
  endreturntable.concat(res, '&')
endpayload = encodepost({
  login = usr,
  password = pwd,
  locale = "nl",
  proceed = "Authorize",
})

For this request Accept/Content-Type headers are not needed. Add redirect = false to the request table to catch the redirect URL instead of following it.

gjniewenhuijse · 22.10.2020, 08:16

(22.10.2020, 07:14)admin Wrote: For auth you need to use standard POST, not JSON:

For this request Accept/Content-Type headers are not needed. Add redirect = false to the request table to catch the redirect URL instead of following it.

mmm same result with changed code

Code:
1234567891011121314151617181920212223242526272829303132333435363738
functiongetAuth()
  functionencodepost(t)
    localres = {}
    localesc = require('socket.url').escapefork, vinpairs(t) dores[ #res + 1 ] = esc(k) .. '=' .. esc(v)
    endreturntable.concat(res, '&')
  endurl = apiHost..endpointAuth..'?client_id=customer_api&response_type=code&redirect_uri='..uri..'&scope=api&state='..statemethod = "POST"localresponse_body = {}  
  localpayload = encodepost({
    login = usr,
    password = pwd,
    locale = "nl",
    proceed = "Authorize",
  })
  localres, code, response_headers, status = socket.http.request
  {
    url = url,
    method = method,
    redirect = false,
    headers =
    {
      ["Content-Length"] = #payload
    },
    source = ltn12.source.string(payload),
    sink = ltn12.sink.table(response_body)
  }
  ifresandcode == 200thenlog(response_body)
    log(res, code, response_headers, status)
  elselog(res, code, response_headers, status)
  endend

***admin*** · 22.10.2020, 08:23

Header is missing:

Code:

1

["Content-Type"] = "application/x-www-form-urlencoded"

gjniewenhuijse · 22.10.2020, 11:20

(22.10.2020, 08:23)admin Wrote: Header is missing:

Code:
1
["Content-Type"] = "application/x-www-form-urlencoded"

yes, now i get the authorization code (authCode).

Next is exchaging the authorization code for an access token, see my code try below.
Doc: https://interop.ondilo.com/docs/api/cust...n-exchange

Code:
123456789101112131415161718
-- exchange the authorization code for an access tokenifauthCodethenurl = apiHost..endpointToken..'?code='..authCode..'&grant_type=authorization_code&client_id=customer_api&redirect_uri='..urimethod = "POST"localresponse_body = {}
    localres, code, response_headers, status = socket.http.request
    {
      url = url,
      method = method,
      headers =
      {
        ["Content-Type"] = "application/x-www-form-urlencoded"
      },
      source = ltn12.source.string(''),
      sink = ltn12.sink.table(response_body)
    }
    log(res, code, response_headers, status)
  end

but as usually i received an error Big Grin

Code:
123456789101112131415161718192021222324252627282930
* arg: 1
  * number: 1
* arg: 2
  * number: 400
* arg: 3
  * table:
   ["server"]
    * string: Apache/2.4.29 (Ubuntu)
   ["content-type"]
    * string: application/json
   ["connection"]
    * string: close
   ["access-control-allow-methods"]
    * string: GET, POST, PUT, PATCH, DELETE, OPTIONS
   ["access-control-allow-headers"]
    * string: X-Requested-With, Content-Type, Accept, Origin, Authorization
   ["cache-control"]
    * string: no-store, no-cache, must-revalidate, max-age=0, post-check=0, pre-check=0
   ["pragma"]
    * string: no-cache
   ["date"]
    * string: Thu, 22Oct202011:14:32GMT
   ["content-length"]
    * string: 97
   ["access-control-allow-origin"]
    * string: *
   ["access-control-allow-credentials"]
    * string: true
* arg: 4
  * string: HTTP/1.1400BadRequest

***admin*** · 22.10.2020, 11:24

You must provide "Content-Length" header for POST requests. Move your GET variables to POST payload:

Code:
1234567
url = apiHost..endpointTokenpayload = encodepost({
  code = authCode,
  grant_type = 'authorization_code',
  client_id = 'customer_api',
  redirect_uri = uri,
})

gjniewenhuijse · (This post was last modified: 23.10.2020, 06:39 by gjniewenhuijse.)

many thanks to admin for the support.

here my first version to get the latest sensor readings for one pool/spa.

We remind that ICO takes measures every hour.
In order to avoid excessive load of our servers, the requests to the Ondilo Customer API
are limited to the following per user quotas :
5 requests per second
30 requests per hour

Access tokens have a lifetime of one hour, while refresh tokens are non-expiring.

***admin*** · 23.10.2020, 06:47

One small improvement, you should use the whole table instead of only the first element. If the JSON response is large enough then the response table will have more than 1 element. Use this instead:

Code:
1
data = json.decode(table.concat(response_body))

MikeBrignate · 21.05.2021, 19:08

Hello

Could you give some instructions with examples how to get sensors data please Shy

I am not familiar with scripting, but can multiply solution from example.

Thank you

***admin*** · 24.05.2021, 09:38

First you need to set usr and pwd variables in the script. Then run this function to get the ID of your pool:

Code:

1

log( getPoolInfo() )

Then you can request the sensor state by calling getSensorInfo:

Code:
12
data = getSensorInfo()
log(data)

When the data format is known the script can be modified to write sensor state to objects.

MikeBrignate · 25.05.2021, 07:12

(24.05.2021, 09:38)admin Wrote: First you need to set usr and pwd variables in the script. Then run this function to get the ID of your pool:

Code:
1
log( getPoolInfo() )

Then you can request the sensor state by calling getSensorInfo:

Code:
12
data = getSensorInfo() log(data)
When the data format is known the script can be modified to write sensor state to objects.

Hello

I have got sensors data, thank you, could you make example of a function for the PUT method?

Thank you

***admin*** · 25.05.2021, 08:19

PUT is the same as POST, just change the method field accordingly

Login
Username:
Password:	Lost Password?
	Remember me