Hi Jan (sorry for the mail-confusion)
Just mailed Xavier this mail below. Also tried with a JSON-stat saved query from SSB
https://www.ssb.no/statbank/sq/10050461
And I cannot make it run.
Is this JSON-stat 2? On SSB there is only one JSON-stat format. On bank.stat.gl we have both versions
LarsP
Hi X,
Thank you so much for remember & sharing. I haven’t looked to Tableau since last summer when I did this short description on how-to and made a simple example
or
https://stat.gl/publ/en/SB/202001/pdf/Tableau%20with%20data%20from%20a%20Statbank.pdf
Spanish is no problem as Silvia is still with us in Nuuk. She was actually born on Gran Canaria and I am sure, she would love to do a Greenlandic version
I took it for a short spin with a JSON-stat 2 file from our statbank
J
Den 9. apr. 2021 kl. 08.37 skrev Jan Bruusgaard <j...@ssb.no>:
We tried this. It works towards the oecd.json test dataset, we could not get it working towards the Statistics Norway's JSON-stat datasets. Interesting to see if it works for you, Lars?
--
You received this message because you are subscribed to a topic in the Google Groups "json-stat" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/json-stat/qu3OQ1glT6s/unsubscribe.
To unsubscribe from this group and all its topics, send an email to json-stat+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/json-stat/26cfc16d-3ec3-4137-b098-cd1f352bc1b7n%40googlegroups.com.
Hi, Lars,
If I understand you right, the canary Tableau connector worked with JSON-stat v2 output from your PxWeb installation?
Then we should look more into why this fail from us. We use tableau quite much, see https://public.tableau.com/profile/statistisk.sentralbyr.statistics.norway.#!/
When I look back at the test we made. I see that tested this connector with JSON-stat version 2 output which I saved as a file on our web. And I did not try to look into why this failed for Thomas at our office. I did no try to contact The Statistical Office of the Canary Islands.
But Thomas got this error from Tableau:
Uncaught TypeError: Cannot read property 'text' of undefined stack:TypeError: Cannot read property 'text' of undefined at Object.success (https://www3.gobiernodecanarias.org/istac/tableau-data-connector/js/app/tableauDataset.js:277:81) at i (https://www3.gobiernodecanarias.org/istac/tableau-data-connector/js/vendor/jquery.min.js:2:27449) at Object.fireWith [as resolveWith] (https://www3.gobiernodecanarias.org/istac/tableau-data-connector/js/vendor/jquery.min.js:2:28213) at y (https://www3.gobiernodecanarias.org/istac/tableau-data-connector/js/vendor/jquery.min.js:4:22721) at XMLHttpRequest.c (https://www3.gobiernodecanarias.org/istac/tableau-data-connector/js/vendor/jquery.min.js:4:26925)
But I confirmed that Thomas got the connector to work without errors from Tableau with https://json-stat.org/samples/oecd.json.
Then to your question:
There is still a bug in our saved query. The saved query lack support for CORS. I think that is the reason for why your saved query from us does not run.
In the PxWebApi we offer both versions, but in the standard PxWeb and the saved queries (sq) that you refer to here, SSB still only offer JSON-stat version 1. The same is the case in the old API with readymade datasets.
Regards,
Jan