Dear Community,
I am writing to report an issue that I have encountered with the automatic upload of images to Airtable, which subsequently causes errors when attempting to upload these images to WordPress via an automated workflow. Here is a detailed account of the observations and steps taken to diagnose and troubleshoot the issue:
Overview of the Issue:
I have implemented an automated workflow using Make.com to generate images using OpenAI's DALL-E, store these images in Airtable, and then upload the images from Airtable to WordPress. However, I am encountering a persistent error when attempting to upload the images from Airtable to WordPress. The error message received is:
```
[500] Sorry, this file type is not permitted for security reasons. (error code: rest_upload_unknown_error)
```
Detailed Observations:
1. Image Generation and Initial Upload:
- Images are generated using OpenAI's DALL-E and are saved in PNG format.
- These images are automatically uploaded to Airtable in an attachment field.
2. Issue with Direct Upload from Airtable to WordPress:
- When attempting to upload the images directly from Airtable to WordPress using the automated workflow, the process fails, and the aforementioned error is encountered.
3. Manual Upload Test:
- To diagnose the issue, I performed the following steps:
- Generated an image using the same automated workflow.
- Downloaded the image manually from Airtable.
- Deleted the originally uploaded image from Airtable.
- Re-uploaded the downloaded image back into Airtable manually.
- When running the automated workflow to upload the manually re-uploaded image from Airtable to WordPress, the process completed successfully without any errors.
Steps Taken to Troubleshoot:
1. Confirmed File Format:
- Verified that the generated images are in PNG format, which is supported by both Airtable and WordPress.
2. File Size and Integrity:
- Ensured that the file size is within acceptable limits and that the images are not corrupted.
3. Metadata and Conversion:
- Considered the possibility that the images might contain metadata or formatting issues when uploaded automatically.
- Added steps in the workflow to convert and resize images before uploading to Airtable to see if it resolves any metadata-related issues.
4. Workflow Steps Overview:
- The workflow includes the following steps:
- Generate image using OpenAI DALL-E.
- Convert and resize the image.
- Upload the image to Airtable.
- Retrieve the image from Airtable.
- Attempt to upload the image to WordPress.
5. Direct Upload Test:
- Attempted direct uploads from Airtable to WordPress using both automatically and manually uploaded images to identify discrepancies.
Conclusion:
The issue appears to be specifically related to how images are handled or stored when uploaded automatically to Airtable. Manually re-uploading the same images to Airtable resolves the issue, allowing them to be successfully uploaded to WordPress. This suggests that there may be a difference in how Airtable processes or stores images uploaded via API compared to those uploaded manually.
Request for Support:
I kindly request your assistance in investigating the following:
1. **Differences in Handling of API and Manual Uploads:**
- Are there any differences in how Airtable handles images uploaded via API versus those uploaded manually through the UI?
2. **Metadata Processing:**
- Does Airtable modify or add any metadata to images uploaded via API that could cause issues with subsequent processing or uploads?
3. **Potential Workarounds:**
- Are there any recommended steps or configurations to ensure that images uploaded via API are treated the same as those uploaded manually?
I appreciate your attention to this matter and look forward to your guidance on resolving this issue.
Thank you for your support.
Best regards,
Michael