Styjun

Has there ever been a cold war other than between the U.S. and the U.S.S.R.?

Are "confidant" and "confident" homophones?

How to ask if a dropped object belongs to someone?

Can a USB hub be used to access a drive from 2 devices?

Mathematical/Algorithmic definition for overfitting

List comprehensions in Mathematica?

Is it possible to spoof an IP address to an exact number?

Machine Learning Golf: Multiplication

The Purpose of "Natu"

Shipped package arrived - didn't order, possible scam?

Is conquering your neighbors to fight a greater enemy a valid strategy?

What instances can be solved today by modern solvers (pure LP)?

Why do Klingons use cloaking devices?

Should I increase my 401(k) contributions, or increase my mortgage payments

Is this standard Japanese employment negotiations, or am I missing something?

How did שְׁלֹמֹה (shlomo) become Solomon?

Can you take the Dodge action while prone?

Change the default text editor in Terminal

Initializing variables variable in an "if" statement

What is the highest level of accuracy in motion control a Victorian society could achieve?

What happens if the limit of 4 billion files was exceeded in an ext4 partition?

How do I iterate equal values with the standard library?

Should I warn my boss I might take sick leave?

How can I effectively map a multi-level dungeon?

GCS API function to get full URL for an image?

How do you get or generate a URL to the object in a bucket?Google Cloud Storage: download a file with a different nameUsing carrierwave to upload images to google cloud storage, the file name ends up being saved and not the public link to the image in the bucketIs it possible to stream data(Upload) to store on bucket of Google cloud storage and allow to download at the same time?Trying to add a hyperlink to Google Sheets via APICreate a Google sheet in DigitalOcean SpaceIs there a way to use an image from the =IMAGE() function as an image src in JavaScript?Playstore Statistics file download From google cloud storage using rest apiSheets API v4 is returning #N/A for specific formulasGet public url for object uploaded on cloud storage

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have some images stored in Google Cloud Storage and I want to display them in a Google Sheets spreadsheet.
The image urls I have are of the form:

https://storage.cloud.google.com/bucket-name/image-name

If I try to put this into the image() formula in Sheets it does not properly display the image.
When following one of these links, it redirects to the image with a URL of the form:

([A-Za-z]d)*-apidata.googleusercontent.com/download/storage/v1/b/bucket-name/o/object-name?qk=([A-Za-z]d)*

Is there a GCS API function or Sheets formula that allows me to get this URL from the first one?

google-sheets google-cloud-storage google-sheets-api google-sheets-formula

share|improve this question

edited Mar 25 at 20:48

Tomka Koliada

1,27022 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 19:35

mwestmwest

644 bronze badges

add a comment | 

0

I have some images stored in Google Cloud Storage and I want to display them in a Google Sheets spreadsheet.
The image urls I have are of the form:

https://storage.cloud.google.com/bucket-name/image-name

If I try to put this into the image() formula in Sheets it does not properly display the image.
When following one of these links, it redirects to the image with a URL of the form:

([A-Za-z]d)*-apidata.googleusercontent.com/download/storage/v1/b/bucket-name/o/object-name?qk=([A-Za-z]d)*

Is there a GCS API function or Sheets formula that allows me to get this URL from the first one?

google-sheets google-cloud-storage google-sheets-api google-sheets-formula

share|improve this question

edited Mar 25 at 20:48

Tomka Koliada

1,27022 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 19:35

mwestmwest

644 bronze badges

add a comment | 

I have some images stored in Google Cloud Storage and I want to display them in a Google Sheets spreadsheet.
The image urls I have are of the form:

https://storage.cloud.google.com/bucket-name/image-name

If I try to put this into the image() formula in Sheets it does not properly display the image.
When following one of these links, it redirects to the image with a URL of the form:

([A-Za-z]d)*-apidata.googleusercontent.com/download/storage/v1/b/bucket-name/o/object-name?qk=([A-Za-z]d)*

Is there a GCS API function or Sheets formula that allows me to get this URL from the first one?

google-sheets google-cloud-storage google-sheets-api google-sheets-formula

share|improve this question

edited Mar 25 at 20:48

Tomka Koliada

1,27022 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 19:35

mwestmwest

644 bronze badges

share|improve this question

edited Mar 25 at 20:48

Tomka Koliada

1,27022 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 19:35

mwestmwest

644 bronze badges

share|improve this question

edited Mar 25 at 20:48

Tomka Koliada

1,27022 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 19:35

mwestmwest

644 bronze badges

edited Mar 25 at 20:48

Tomka Koliada

1,27022 gold badges88 silver badges2828 bronze badges

edited Mar 25 at 20:48

Tomka Koliada

1,27022 gold badges88 silver badges2828 bronze badges

asked Mar 25 at 19:35

mwestmwest

644 bronze badges

asked Mar 25 at 19:35

mwestmwest

644 bronze badges

1 Answer
1

active

oldest

votes

0

You are receiving the ([A-Za-z]d)*-apidata.googleusercontent.com/download/storage/v1/b/bucket-name/o/object-name?qk=([A-Za-z]d)* link because you are trying to access a private image.

When you copy the link of the private object and you paste it on the browser, Google checks your credentials. If the account you are using has enough permissions to view the object, then it redirects you to the api.data link.

You can test this by copying the link of the object on the Cloud Console and then pasting it on incognito mode. You will see that it will prompt you for an account. But, if you paste the api.data link on incognito, it will still give you the object.

The easiest solution will be to define the image as Public and then copying the Public URL on the sheets page. It will be something like:

storage.googleapis.com/bucket/image.jpeg

share|improve this answer

answered Mar 26 at 8:53

Nahuel VarelaNahuel Varela

72322 silver badges1616 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55345215%2fgcs-api-function-to-get-full-url-for-an-image%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You are receiving the ([A-Za-z]d)*-apidata.googleusercontent.com/download/storage/v1/b/bucket-name/o/object-name?qk=([A-Za-z]d)* link because you are trying to access a private image.

When you copy the link of the private object and you paste it on the browser, Google checks your credentials. If the account you are using has enough permissions to view the object, then it redirects you to the api.data link.

You can test this by copying the link of the object on the Cloud Console and then pasting it on incognito mode. You will see that it will prompt you for an account. But, if you paste the api.data link on incognito, it will still give you the object.

The easiest solution will be to define the image as Public and then copying the Public URL on the sheets page. It will be something like:

storage.googleapis.com/bucket/image.jpeg

share|improve this answer

answered Mar 26 at 8:53

Nahuel VarelaNahuel Varela

72322 silver badges1616 bronze badges

add a comment | 

0

You are receiving the ([A-Za-z]d)*-apidata.googleusercontent.com/download/storage/v1/b/bucket-name/o/object-name?qk=([A-Za-z]d)* link because you are trying to access a private image.

When you copy the link of the private object and you paste it on the browser, Google checks your credentials. If the account you are using has enough permissions to view the object, then it redirects you to the api.data link.

You can test this by copying the link of the object on the Cloud Console and then pasting it on incognito mode. You will see that it will prompt you for an account. But, if you paste the api.data link on incognito, it will still give you the object.

The easiest solution will be to define the image as Public and then copying the Public URL on the sheets page. It will be something like:

storage.googleapis.com/bucket/image.jpeg

share|improve this answer

answered Mar 26 at 8:53

Nahuel VarelaNahuel Varela

72322 silver badges1616 bronze badges

add a comment | 

You are receiving the ([A-Za-z]d)*-apidata.googleusercontent.com/download/storage/v1/b/bucket-name/o/object-name?qk=([A-Za-z]d)* link because you are trying to access a private image.

When you copy the link of the private object and you paste it on the browser, Google checks your credentials. If the account you are using has enough permissions to view the object, then it redirects you to the api.data link.

You can test this by copying the link of the object on the Cloud Console and then pasting it on incognito mode. You will see that it will prompt you for an account. But, if you paste the api.data link on incognito, it will still give you the object.

The easiest solution will be to define the image as Public and then copying the Public URL on the sheets page. It will be something like:

storage.googleapis.com/bucket/image.jpeg

share|improve this answer

answered Mar 26 at 8:53

Nahuel VarelaNahuel Varela

72322 silver badges1616 bronze badges

storage.googleapis.com/bucket/image.jpeg

share|improve this answer

answered Mar 26 at 8:53

Nahuel VarelaNahuel Varela

72322 silver badges1616 bronze badges

answered Mar 26 at 8:53

Nahuel VarelaNahuel Varela

72322 silver badges1616 bronze badges

answered Mar 26 at 8:53

Nahuel VarelaNahuel Varela

72322 silver badges1616 bronze badges