Best Of
Re: Multiple Case statements
@JackB116 you are on the right track. When you want to look at multiple conditions, you want to use 'and'. So you would just replace 'then when' with 'and'
CASE when `Invoiced Month` in ('10', '11', '12')
and 'Invoiced Year' = '2022'
and `Sales Order Type` in ('PRE ORDER', 'PRE ORDER POST DEADLINE') then `Row Net` else 0 end
Integrate with Monday.com
Do you know if there is an extension that allows us to integrate with "Monday.com" or any plans in the future to implement this?
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.