Best Of
Details about, and alternatives to, the DataSet query API
I gave the datasets/query/execute v1 API a try today, and have a few questions:
* What idiom of SQL is this using? It took me some time to get the name escaping done in a way that Domo tolerated.
* Is there any dedicated documentation on the system, other than the sparse details I've found at
https://developer.domo.com/docs/dataset-api-reference/dataset#Query%20a%20DataSet
* Is there a way to get the results as something other than an array of JSON objects, like TSV/CSV, or something else a bit more compact?
* Are there better, more recent alternatives to datasets/query for querying DataSets?
Thanks!
Re: Restricting Access to card based on Criteria
@Logan_Jolly That sounds like a good time to implement PDP's. For the PDP's you would need to set up a trusted attribute (email, employee id) that you use in the data to identify their data in the table rows. You would then add users who need to see everything to the All Data PDP, and then set up a PDP using that trusted attribute and add the field members or an everyone group to that PDP. Then each field member would only be able to see the data that is tied to them, and anyone in the all data PDP could see everything.
Re: Restricting Access to card based on Criteria
@Logan_Jolly Depending on what the restriction is you want to apply and your data, you could look into PDP's. This would be applied to the dataset, so as long as the PDP would be fine across any card on this dataset, then you could set up a PDP so the user can only see a certain department or type of product or any other condition.
Re: How do I convert a 12 Hour Time into a 24 Hour time
@Devin_Garrison As a side note, if you just need those timestamps to show up in a card in 24 hour format, it actually displays them that way without needing to do anything. I tried it out with a couple of timestamp columns in my data and it displayed everything in 24 hour format. It seems that when you look at them at the dataset level, Domo displays them in 12 hour format.
Re: How do I convert a 12 Hour Time into a 24 Hour time
DATE_FORMAT function if your friend in this case. You can format the date as a specific string format.
You can find more information on the codes used here: https://www.w3schools.com/sql/func_mysql_date_format.asp
DATE_FORMAT(`Date`, '%Y-%m-%d %H:%i:%s')
