[Resolved] I have tried to connect my Custom post type in WordPress to Activepieces so that
This thread is resolved. Here is a description of the problem and solution.
Problem:
The customer was trying to connect their custom post type in WordPress to Activepieces to create multiple custom post types from data in Google Sheets. Although the connection was established without errors, the imported custom post types were completely blank.
Solution:
We identified that the option to "Expose custom fields managed by Types for posts, users, and terms through the REST API" is primarily for exporting data rather than importing. We suggested the customer check if they were using the WP All Import plugin, which has an add-on for Toolset Types, to handle the import process more effectively. Additionally, we recommended exporting data from Activepieces to a CSV file and then importing that CSV into Toolset using available CSV import plugins, as this could simplify the import process and ensure the data is processed correctly.
I have tried to connect my Custom post type in WordPress to Activepieces so that I can create multiple CPT from my data in Googlesheets. I have managed to connect them and there is no error code, but the new CPT that are imported across are completely blank. See top post 'no title' in my Toolset CPT for Volunteer places.
Can you help with this?
I get this message in Activepeices:
yoast_head:"<!-- This site is optimized with the Yoast SEO plugin v23.4 - hidden link --> <title>- London National Park City</title> <!-- Admin only notice: this page does not show a meta description because it does not have one, either write it for this page specifically or go into the [Yoast SEO - Settings] menu and set up a template. --> <meta name="robots" content="index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1" /> <link rel="canonical" href="hidden link" /> <script type="application/ld+json" class="yoast-schema-graph">{"@context":"hidden link","@graph":
That refers to particular plugins, but the data import landscape changes over time, and the principles should apply to other generic import tools, too.
I need to ensure that the REST API is applied to the custom post type and the custom fields - I have gone into setting, custom and ticked 'Expose custom fields managed by Types for posts, users, and terms through the REST API' already but its still not importing the information from the Googlesheet
The option 'Expose custom fields managed by Types for posts, users, and terms through the REST API' is primarily useful for exporting data using Toolset, rather than importing it from an external source.
Some Types fields are stored as serialized arrays, which makes the import process more complex. The data needs to be processed upon import, rather than simply being copied into the database as-is.
We are aware that WP All Import offers an add-on for Toolset Types: hidden link
This is their product, and although I'm not completely familiar with it, I expect the integration handles cases like this one.
Additionally, it appears that Activepieces integrates with WP All Import, so you might want to check how to connect the two tools: hidden link
You might want to try this and see if it resolves your issue.
Alternatively, WP All Import allows you to apply a PHP function to any imported field, which can transform the data before saving it.
Another approach could be a two-step process: exporting from Activepieces to a CSV file and then importing that CSV file into Toolset. Several CSV import plugins are available, and these guides may be helpful: