Dataset Switching using vb.net

AdmissionPros · September 2021

Does any one have experience with dataset switching using vb.Net to switch datasets on the fly? We are having issues getting the json string generated. Any help would be greatly appreciated!

jaeW_at_Onyx · September 2021

'switch datasets' ... what do you mean?

AdmissionPros · September 2021

using datasetRedirects at run time. Basically changing the dataset for all cards on a dashboard on a webpage. Lets say you have a database with 2 tables in it - both have the same exact structure. Instead of combining the data from both tables into 1 table and using programmatic filtering you can swap out the datasets for a dashboard at runtime by using datasetRedirects. We cannot get this to work in .net

jaeW_at_Onyx · September 2021

https://developer.domo.com/docs/embed/dataset-switching

i assume this is what you're talking about.

are you able to get the desired outcome using other embed methods? what code are you writing that does not work?

(caveat, i don't know much about vb.net, but "it's not working" is a bit hard to troubleshoot :P )

AdmissionPros · September 2021

We are an angular shop. So we can only use .Net

Dim embedTokenRequest As New HttpRequestMessage() With {

.RequestUri = New Uri(embedAuthUrl),

.Method = HttpMethod.Post,

.Content = New StringContent(JsonConvert.SerializeObject(New With {

Key .sessionLength = 1440,

.authorizations = {

New With {Key .token = embedId,

.permissions = {"READ", "FILTER", "EXPORT"},

.datasetRedirects = {"v1:v2"}

.filters = {New With {Key .column = "ENTRY_YEAR", .operator = "GREATER_THAN", .values = {"2020"}}},

.policies = Nothing}

}

}))

}

The resulting JSON string is supposed to be formatted like Domo's example: on https://developer.domo.com/docs/embed/dataset-switching. However we cannot get the resulting json string to be "dataSetFrom":"dataSetTo"

visualization1: {

clientId: process.env.CLIENT_ID, clientSecret: process.env.CLIENT_SECRET, embedId: process.env.EMBED_ID1,

datasetRedirects: {

"a19d0ef1-ca31-4bfd-b168-018b93109671":"a19d0ef1-ca31-4bfd-b168-018b93109672",

"a19d0ef1-ca31-4bfd-b168-018b93109673":"a19d0ef1-ca31-4bfd-b168-018b93109674"

},

filter: {"@type":"IN","leftExpression":{"@type":"COLUMN","columnName":"color"},"rightItemsList":{"@type":"EXPRESSION_LIST","expressions":[{"@type":"STRING_VALUE","value":"red"}]}}

},

}

jaeW_at_Onyx · September 2021

.datasetRedirects = {"v1:v2"}

this looks problematic (compared to the rest of the code you're writing.

shouldn't it be

.datasetRedirects = { .v1 = v2"}

or something similar.

AdmissionPros · September 2021

V1 and V2 are just variables. Ultimately the resulting json needs to be formatted like:

"a19d0ef1-ca31-4bfd-b168-018b93109671":"a19d0ef1-ca31-4bfd-b168-018b93109672"

jaeW_at_Onyx · September 2021

i understand. i'm questioning whether the code you've written would actually return that result. what json ARE you getting?

Dataset Switching using vb.net

Answers

Categories