Uploading to GDrive failed after successful "Send API Request for Dall-E 3" action
Hi All,
I’m hitting s hard-wall on what I’m trying to achieve: I’d like to generate an image with Dall-e 3 and upload it on a GDrive.
Since I don’t seem to have the dall-e 3 model available in the send prompt, I used Troy’s suggestion (Here) and used the API Request, with all correct parameters. As a matter of fact I got the the 200 response code and the URL on the Azure Blob (https://oaidalleapiprodscus.blob.core.windows.net/private...etc etc).
The issue comes with step 2 (i.e. Upload on GDrive). When I enter the previous URL (i.e. “Response Data Data URL”) in the Gdrive - Upload action, it doesn’t work and I get the following error:
“Failed to create an upload file in Google Drive
The app returned "Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.".“
Can someone please help me figuring out what’s missing?
Many thanks in advance,
Alex
Page 1 / 1
Hi @Xperim0660
Good question.
Please post screenshots with how your GDrive Zap step is configured to give us context.
Hi @Troy Tessalone ,
many thanks for your feedback. Here’s the screenshot.
Basically, the flow goes as follows:
get a record from Sheets;
perform a check on 1 field of the extracted record; this is needed just to ensure the data is actually ready to be processed by the next action;
generate images via API request (here I basically call the API you’ve also mentioned in a previous post. All parameters are correct, and gives me back a Response Data URL
I find a specific PNG file on GDrive;
I replace it (see screenshot above) with the Response Data Data Url I get from OpenAI API.
I’m aware the URL has an expiration, and I’ve tried to access it within 1 minute of its generation, but it doesn’t work and gives me the following error:
I was wondering if, instead of the default response_format “url” (from Dall-E 3), I should actually request a “b64_json” and manipulate that afterwards (even though I wouldn’t know how to handle that in Zapier, without writing custom python code).
Any suggestions you might have would be very welcome!
Many thanks in advance,
Alex
@Xperim0660
Can you show how the OpenAI step is configured along with the returned data?
Hi @Troy Tessalone ,
sure, here it is:
...and the output, after having run the test is this:
...scrolling further down in the output, you can see the generated response data URL:
{ "created": 1700553879, "data": 8 { "revised_prompt": "Imagine a domestic feline exhibiting a supernatural strength. The cat has a vibrant fur, a mixture of orange and white, with expressive green eyes. It effortlessly carries a small miniaturized grand piano, classical in design with a glossy black finish. The keys are clean and white, contrasting beautifully against the black body. Despite the piano's size being quite smaller than the usual, it still appears quite significant in comparison to the cat. Feel the amusing absurdity of the scene.", "url": "https://oaidalleapiprodscus.blob.core.windows.net/private/:censored:28:ff05a144d3:/user-aOMITTED]/img-eDk7SinJ4tO62NCZ3NmvPUZs.png?st=2023-11-21T07%3A04%3A39Z&se=2023-11-21T09%3A04%3A39Z&sp=r&sv=2021-08-06&sr=b&rscd=inline&rsct=image/png&skoid=6aaadede-4fb3-4698-a8f6-684d7786b067&sktid=a48cca56-e6da-484e-a814-9c849652bcb3&skt=2023-11-20T20%3A16%3A33Z&ske=2023-11-21T20%3A16%3A33Z&sks=b&skv=2021-08-06&sig=fHV3rU90j2czMvTSfzfA3mX%2BkrzixmP%2BR5nsAiqp5rc%3D" } ] }
data
created
1700553879
data
1
revised_prompt
Imagine a domestic feline exhibiting a supernatural strength. The cat has a vibrant fur, a mixture of orange and white, with expressive green eyes. It effortlessly carries a small miniaturized grand piano, classical in design with a glossy black finish. The keys are clean and white, contrasting beautifully against the black body. Despite the piano's size being quite smaller than the usual, it still appears quite significant in comparison to the cat. Feel the amusing absurdity of the scene.
This is very strange indeed. It looks as though you’ve got the Zap set up correctly. I’ve just done some testing in my own account and was able to successfully generate an image, view it at the URL provided and upload it to a Google Drive folder, based on the same set up as shown in your screenshots.
The images should expire after 1 hour according to OpenAI’s documentation so it should give plenty of time for the Zap to process them. As the error is referencing an issue with the authentication perhaps there could be something wrong with the API Key?
To test out that theory can you try the following:
_full_response_data_
