Skip to main content

Hello all. First time posting a question and I am not a coder so if you choose to reply, go easy on me. TIA.

I'm trying to troubleshoot why a post is giving me errors when running a test. I keep getting "missing required parameter”  

I'm trying to create a zap that converts content from PDFs into an air table that I can evaluate multiple pdf docs quickly. My workflow is to collect a PDF, (attachment and content kept in air table), convert the PDF to text (pdf.co), extract the text from pdf.co (Webhooks by zapier - GET), then post the data as a json. 

I am able to successfully set the first  three steps up in ZAPIER, (airtable, pdf.co, and webhook - get) however, I keep receiving errors when I go through the test using Webhooks -Post. 

I am using ChatGPT to assist with instruction, but is becoming quite infuriating and I have blown several hours trying to troubleshoot this step, making the whole point of automation and saving time quite ironic.

I have set up the URL, payload as JSON, and have broken out data into six points (model, temperature, and 4 messages). 

I'm getting conflicting feedback from ChatGPT that it could be this syntax on how I'm setting up messages (ie messagesm0].role, and now it is suggesting thatZapier has no Patch or Work around for using API codes with a sk-proj prefix. 

So I'm confused as to what the actual origin of the problem is.

Any help would be appreciated

TIA

Hi ​@jasondag 

For us to have more context, provide more info about these:

  • screenshots showing how your Zap step is configured in EDIT mode with the field mappings visible
  • link to the API endpoint documentation you used to configure the API request

 


Thanks for the reply,
 

Below are screen shots of the edit mode:

 

Let me know if I have missed anything or anything else I can share that will help you assist me. Thanks in advance.


@jasondag 

Why not use this Zap app?

ChatGPT/OpenAIhttps://zapier.com/apps/chatgpt/integrations#triggers-and-actions

 

 


Thanks for this. As a newbie, I'm not familiar with many of these options and certainly not this one. Although I should be following the logic, I'm not quite following. Are you suggesting the ChatGPT trigger “conversation” well dissect information from a PDF and import into air table based on the data I want to extract and evaluate?


@jasondag 

Instead of trying to use a custom API request for Zap step 4, why not use the available ChatGPT/OpenAI Zap app integration and available actions: https://zapier.com/apps/chatgpt/integrations#triggers-and-actions


I see. The thing is, I wanted to parse and map values (i.e. provides scores x/10 based on certain criteria), and it looks like this would just return as block of plain text instead of a JSON structure. Would I just expand this in the "instructions" Field Or should I use something else?


@jasondag 

If you use the ChatGPT/OpenAI or Webhook apps to make an API request, then Zapier automatically parses the response, meaning it will not return raw JSON.

If you use a Code step to make the API request, then you can handle the API response however you want.

 

Why not include the desired JSON structure for ChatGPT/OpenAI to return the data in?

Then you can use a Code step to parse the JSON response.

 

 


Right, I hadn't thought of that option. I asked GPT to add to the instruction for the JSON formet and it seems to work. I have a small unrelated issue having it reference the PDF to get reference to, but that's another workflow issue with airtable.

Really appreciate the insights, thank you, Troy!