[Resolved] I have tried to connect my Custom post type in WordPress to Activepieces so that

[Author]

Posts

[sadimG1199]

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":

[Nigel]

Hi there

Could we get more information about what you are doing?

What is activepieces? How are you importing data for your posts?

If you want to import data in Google sheets into WordPress as posts it might help to look through our documentation about importing CSV files: https://toolset.com/course-lesson/how-to-import-content-into-wordpress-using-csv/

That refers to particular plugins, but the data import landscape changes over time, and the principles should apply to other generic import tools, too.

[sadimG1199]

Hi Nigel,

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

I found this document on how to do it. https://toolset.com/documentation/programmer-reference/toolset-integration-with-the-rest-api/?utm_source=plugin&utm_campaign=types&utm_medium=gui&utm_term=rest-api-integration

but i have no idea how to do that.

This is my Activepeices flow - hidden link

[Mateus Getulio]

Hello,

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:

https://toolset.com/course-lesson/how-to-import-content-into-wordpress-using-csv/
https://toolset.com/course-lesson/importing-content-from-csv-with-post-relationships/
https://toolset.com/course-lesson/how-to-import-posts-from-csv-files-and-maintain-relationships-when-using-the-csv-importer-plugin/
https://toolset.com/related-lesson/export-import/

I hope this helps! Please let me know if you need further assistance.

Regards,
Mateus