Skip Navigation

[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.

Relevant Documentation:

https://www.wpallimport.com/toolset-types-add-on/
https://toolset.com/course-lesson/how-to-import-content-into-wordpress-using-csv/
https://community.activepieces.com/t/api-for-wp-all-export/5755

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 9:00 – 12:00 -
- 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 13:00 – 18:00 -

Supporter timezone: America/Sao_Paulo (GMT-03:00)

This topic contains 3 replies, has 3 voices.

Last updated by Mateus Getulio 4 months, 3 weeks ago.

Assisted by: Mateus Getulio.

Author
Posts
#2742895
Screenshot 2024-09-09 181033.png

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

#2743312

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

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.

#2743682

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

#2743873

Mateus Getulio
Supporter

Languages: English (English )

Timezone: America/Sao_Paulo (GMT-03:00)

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