Best Of
Re: Is there a way to retrieve or export cards data to csv using Domo API?
You need to pass your API token in under the X-DOMO-DEVELOPER-TOKEN header variable (assuming you generated it under More - Admin - Authentication - Access Token) not the Authorization header.
curl -v -H X-DOMO-DEVELOPER-TOKEN:'{access-token}' "https://[INSTANCE].domo.com/api/content/v1/cards/<card_id>/export"
Re: Is there a way to retrieve or export cards data to csv using Domo API?
Ah I misunderstood the request. There is an export-data option with the CLI to export a dataset which can take a query so you could attempt to replicate the query your card is using and pass that along through the CLI but as @MarkSnodgrass mentioned you may need to watch the traffic to get the exact query it’s using
Re: Filters that persist between pages
No, anchor links aren't supported in Domo. A somewhat clunky solution would be to utilize pfilters to directly link to different pages with predefined filters but if they navigate their on their own without using those links the filters won't be applied. It'd be difficult to translate the currently selected filters to an actual pfilter link though but thought I'd let you know it's existence if it would benefit your use case. Domo Embed/Everywhere supports persistent filters but Domo proper does not.
Re: Filters that persist between pages
Hi @Chris_Hippo
Currently this isn’t possible to do. Id recommend adding it to the idea exchange.
If you want your filters to affect your different cards then they’d have to be all on the same page.
Re: Using an interaction as a filter on another story page?
Hi @mberkeley
Currently this isn't possible as Domo generates the query behind the scenes on their end based on what you click on in the card and doesn't support GET parameters (parameters in your URL after the ?). This would be a great thing and I'd recommend adding it as an idea or talk with your CSM.
Re: DOMO - Timestamp
Instead of using STR_TO_DATE just use your time string you're wanting to add to your current date
`Time_From_Column` BETWEEN ADDTIME(CURRENT_DATE() , '00:06:66') AND ADDTIME(CURRENT_DATE(), '00:07:05')
Re: Employee Tenure Based On Hire Date
This is what we use for tenure in years:
DATEDIFF(CURDATE(),`hire_date`)/365
AS
Re: Centering a Summary Number
@Ashleigh based on the resulting HTML code on the cards it doesn't appear that you can center the summary number in relation to the chart below. I'd toss an idea into the idea exchange for it.
Re: Api fails for filters
Alongside this thread and awaiting the advice of the technical adept users, reach out to Support [support.domo.com] to have them look at it as well (and escalate to Dev if need be).
amehdad
Re: what does the delta symbol mean on my data flow ?
Hi, how did you go? If what I wrote helped, please make sure to mark it as an accepted answer so that others can easily find this. Thank you!
amehdad