0

mixing 'do as database' with 'do as server'

A do as database is executed on the client, but I want to execute a do as server in the do as database loop. Is this possible? For example, execute the code below:

do as database
   for i in select Clients do
       let iref := i.'invoice_ref';
       let resp := do as server
                       http("GET", "https://directory.website.com/search/1.0/json?q=" + iref)
                   end;
       if resp.result.'total-result-count' > 0 then
           i.(Field1 := 1)
       else
           i.(Field1 := 2)
   end
end

Antwort

null