Hi @Troy Tessalone ,

many thanks for your feedback. Here’s the screenshot.

Basically, the flow goes as follows:

1. get a record from Sheets;
2. 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;
3. 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
4. I find a specific PNG file on GDrive;
5. 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   

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:

🔍_full_response_data_🔎

https://zapier.com/engine/hydrate/15336316/.eJw1zU0OgjAQhuG7zBq0tT9Ydp7DGFLawTRAS2iJEsLdrUS37zd5ZgMTfEKfmrROCDXcoADnY9LeYOMs1JyxC2UVK8AsMYVxiTgfAxWMSUZlAdqYsGTiXwUnqoDO4WA[OMITTED...it’s basically the data below]

request

method

POST

url

https://api.openai.com/v1/images/generations

querystring

headers

content-type

application/json

body

{ "model": "dall-e-3", "prompt": "a cat carrying a piano", "n": 1, "size": "1024x1024" }

data

model

dall-e-3

prompt

a cat carrying a piano

n

1

size

1024x1024

response

status

200

headers

access-control-allow-origin

*

alt-svc

h3=":443"; ma=86400

cf-cache-status

DYNAMIC

cf-ray

82976bfe3853081b-IAD

connection

close

content-encoding

gzip

content-type

application/json

date

Tue, 21 Nov 2023 08:04:39 GMT

openai-organization

[OMITTED]

openai-processing-ms

13196

openai-version

2020-10-01

server

cloudflare

set-cookie

__cf_bm=hrPS3zaoMw6p0xGONpMipomKhnwiY5x1qrMUnekavPY-1700553879-0-AVHu69cBK3f2/lYRuR30jEpED95l1Cu5CgCPS1BSCB3ejcn9yeESUJqQ37BQmThRH9d877BGDSwRJzN80ZdKknA=; path=/; expires=Tue, 21-Nov-23 08:34:39 GMT; domain=.api.openai.com; HttpOnly; Secure; SameSite=None, _cfuvid=j94WNImtOz1o3xEMH0ywXX.jldEGk0CVePYs0FPqnpk-1700553879199-0-604800000; path=/; domain=.api.openai.com; HttpOnly; Secure; SameSite=None

strict-transport-security

max-age=15724800; includeSubDomains

transfer-encoding

chunked

x-request-id

7a5ac4e450b9cb723e786dcbcb2c94bf

body

{ "created": 1700553879, "data": [ { "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-[OMITTED]/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.

url

https://oaidalleapiprodscus.blob.core.windows.net/private/:censored:28:ff05a144d3:/user-[OMITTED]/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

Any idea what is happening?

Thanks a lot in advance for your help,

Massimo

@Xperim0660 

I tested too and was able to successfully replace a GDrive file with an image from OpenAI.

Make sure to retest each Zap step.

Also, try turning the Zap ON and testing live.