Number of rows returned in query?

[JHASean]

Is there a way to get the number of rows returned in a query?

[Kevin-C · Accepted solution]

Hey @JHASean 

If you're trying to get HubDB data into an object usable by javascript. and depending on how you're developing you could:

• Use the json API
• Use Hubl to output JSON using the tojson filter
• Use Hubl to manually build your JS object
  

  const dataFromDB = {
    keyName00: "{% var.key00 %},
    keyName01: "{% var.key01 %},
    keyName02: "{% var.key02 %}
    }

Im sure there is at least 1 other, if not many other options to accomplish