Dataset Switching using vb.net

AdmissionPros

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

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

AdmissionPros

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

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

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

.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

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

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