How do I construct my desired query?

Jazeppi

I am creating a card in DOMO, and I am trying to query from my dataset. I want to query in such a way so that I first query the dataset only for its column names, then I use the column names to query all the data in the dataset. This is what I have so far:

I am getting the following error, however: "Uncaught TypeError: Cannot read properties of undefined (reading 'join')
at <anonymous>:410:56
at CodeService.ts:90:29" Furthermore, my "console.log(fields1)" statement prints undefined. Does anyone know how I can accomplish my desired query?

GrantSmith

The issue is that your metadata variable is undefined and you need to handle the Promise. I'd try to do something like:

domo.get(metadataQuery, {format: 'array-of-arrays' }).then(function proces_metadata(metadata) {
  fields1 = metadata.columns
  …
  domo.get(query1).then(…)
}

)

GrantSmith

The issue is that your metadata variable is undefined and you need to handle the Promise. I'd try to do something like:

domo.get(metadataQuery, {format: 'array-of-arrays' }).then(function proces_metadata(metadata) {
  fields1 = metadata.columns
  …
  domo.get(query1).then(…)
}

)