Best Of
Re: How to import Several XMLs from SharePoint in 1 setup?
Currently this isn't possible with the direct Share point connector. You'd need to script this yourself to automatically ingest all of the files.
Re: How to import Several XMLs from SharePoint in 1 setup?
You'd need to utilize a scripting language like Python and the Domo and Sharepoint SDKs to programmatically query your folder, pull and parse the data and then ingest it into your Domo instance. There isn't a tutorial on how to do this specific use case but you could reference the documentation for each of the different SDKs.
Alternatively you could attempt to write a custom connector that would support importing multiple files. There's some documentation on this at https://developer.domo.com
Both options are going to be very technical.
Re: Please URGENT ***Dashboard on DOMO***
I suggest you check out this article on some of Domo's Period-over-Period chart types: https://domo-support.domo.com/s/article/360042924834?language=en_US
If it has to be in table format, then this write-up by @GrantSmith also has some helpful tips for making your own PoP comparisons: https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons
Re: How to get the time difference between completed and originated on 8 hour shift minus weekends
Hi @Devin_Garrison are you trying to get to the difference by minute or hour or day?
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.