Number of rows returned in query?

[JHASean]

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

[Kevin-C]

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