Csv sharing

Get Help
1

Hey guys, there was a time when we could make .csv request for shared questions.

I absolutely love this feature … Have you deleted it ?

2

Hi @dardar
I don’t understand what you’re asking for. Can you provide a bit more information or a screenshot?
And also post “Diagnostic Info” from Admin > Troubleshooting.

3

Hi !

Thanks. So about 3 to 4 months ago, we could share questions in public, and futhermore in csv/json. Now I don’t see this anymore it was in the pink part of this screenshot

It was really great because I could consume metabase questions with third parties application really easily.

4

Hi @dardar
It sounds like you’re talking about this issue:
https://github.com/metabase/metabase/issues/12406
It’s fixed in the upcoming 0.37.0 (no release date yet).
Workaround: You can manually add .csv or .xlsx or .json after the public URL

5

Unfortunately, it doesn’t work with the adding of .csv after the public URL.

At least with the ImportData function from googlesheet

6

@dardar It would help if you provided all those information from the beginning. You’re seeing this issue:
https://github.com/metabase/metabase/issues/11974 - upvote by clicking :+1: on the first post

7

I’m having trouble finding the most recent resolution on this.


^^This seems to be the most recent but I’m not able to use IMPORTDATA to pull a report into Sheets.
Any help or update would be really appreciated!

8

@shansay What do you mean? The PR you are linking to was merged on 2020-10-22 and was part of version 0.36.8, which was released on 2020-10-23.
Without more details, it’s difficult to know what problems you’re having.
Post “Diagnostic Info” from Admin > Troubleshooting.

9

First of all - thanks for the super quick response!
And, yes sorry about that - more detail. It’s my understanding that we should be able to use the public link adding .csv in a spreadsheet with the =IMPORTDATA( function but I get an error. So while I saw that that was merged, I’m getting an error. I started on a thread that was further back but ended up with the post above (11974) but maybe I’m doing something incorrectly? Shouldn’t I be able to use the IMPORTDATA function in Sheets to import from a metabase report?
Thanks again for your help!

10

@shansay

  1. Post “Diagnostic Info” from Admin > Troubleshooting.
  2. Make sure that the URL is actually accessible publicly.
  3. Post the error you are getting in Google
  4. Check the Metabase log to see if there are any activity, when you see the error in Google - Admin > Troubleshooting > Logs.
11

Oh, sorry again!

  1. Diagnostic info below
  2. Sharing is enabled publicly
  3. Formula parse error
  4. I’m not familiar enough to understand this :confused:

{
“browser-info”: {
“language”: “en-US”,
“platform”: “MacIntel”,
“userAgent”: “Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.10+9”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.10”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.10+9”,
“os.name”: “Linux”,
“os.version”: “4.14.209-160.339.amzn2.x86_64”,
“user.language”: “en”,
“user.timezone”: “GMT”
},
“metabase-info”: {
“databases”: [
“postgres”,
“googleanalytics”
],
“hosting-env”: “unknown”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “12.5”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.18”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2021-02-19”,
“tag”: “v0.38.0.1”,
“branch”: “release-x.38.x”,
“hash”: “0635914”
},
“settings”: {
“report-timezone”: “UTC”
}
}
}

12

@shansay Latest release is 0.38.1
I don’t know what formula error is, so figure out how to get the full error.
Or even better post a link to a CSV which you can share publicly.