On CKAN-based site, Web.Contents works with one form of URL, redirects with "versioned" form of URL

[Anonymous]

Our business uses a CKAN-based website with resource download URLs in two forms:

This standard form that always points to the latest version of a resource: 

https://<ckan site home>/dataset/<dataset id>/resource/<resource id>/download

This versioned form with a /version/ part and version id tacked on that points to specific version of a resource:

https://<ckan site home>/dataset/<dataset id>/resource/<resource id>/version/<version id>/download

The standard form of the URL successfully returns data, but the versioned form always redirects to our ckan site's login page.

I have tried tacking on the version part using a RelativePath parameter (versus including it in the URL argument), but this does not correct the behavior. FWIW, we do not have any problem accessing a specific version of a resource (using its versioned URL) programatically via the Python or CKANR APIs.

Here is the M Query that returns data with a standard URL but redirects to login with a version URL:

let
    Source = Web.Contents("<ckan download url>", [Headers=[Authorization="<site access-token>"]])
    Data = Csv.Document(Source, [Delimiter=",", Columns=26, Encoding=1252, QuoteStyle=QuoteStyle.None])
in
    Data

Any thoughts? Thanks!

[PhilipTreacy]

Hi @Anonymous 

The redirection behaviour is down to the webserver and how it's dealing with the HTTP request it receives.  Preumably trying to access a versioned resource in your web browser results in the same redirect behaviour?

If you have an API for accessing resources, try using that in PQ to get the data.

regards

Phil