MinistryPlatform icon

MinistryPlatform

Consume MinistryPlatform API for church management data operations

Actions6

Overview

This node integrates with the MinistryPlatform API, a church management system, to perform data operations on various resources such as tables and stored procedures. Specifically, for the Table - Create operation, it allows users to create one or more new records in a specified MinistryPlatform table by providing the field values for each record.

Common scenarios where this node is beneficial include:

  • Adding new contacts, participants, events, donations, or volunteers into the MinistryPlatform database.
  • Automating bulk data entry from external sources into MinistryPlatform tables.
  • Integrating MinistryPlatform with other systems to keep data synchronized by programmatically creating records.

For example, you could use this node to create multiple new contact records by supplying an array of objects, each containing fields like First_Name, Last_Name, and Contact_ID.

Properties

Name Meaning
Table Name The name of the MinistryPlatform table where new records will be created. Common tables include Contacts, Participants, Events, Households, Groups, Donations, Volunteers, etc.
Records A JSON array of record objects to create. Each object should contain field names and their corresponding values for the new record. Example: [{"Contact_ID": 159, "First_Name": "John", "Last_Name": "Doe"}, {...}].

Output

The node outputs an array of JSON objects representing the newly created records as returned by the MinistryPlatform API. Each object corresponds to a record created in the specified table and includes the fields and values assigned by the API (which may include generated IDs or timestamps).

No binary data output is produced by this operation.

Dependencies

  • Requires an active connection to the MinistryPlatform API.
  • Requires an API authentication credential configured in n8n to authorize requests.
  • The node uses HTTP methods (POST for create) to interact with the MinistryPlatform REST endpoints.

Troubleshooting

  • Invalid JSON format in Records: If the Records input is not valid JSON or is not an array, the node will throw an error indicating invalid JSON format. Ensure that the Records property contains a properly formatted JSON array of objects.
  • API Authentication Errors: If the API key or credentials are missing or incorrect, the node will fail to authenticate. Verify that the MinistryPlatform API credentials are correctly set up in n8n.
  • Table Name Issues: Providing an incorrect or non-existent table name will result in API errors. Confirm the table name matches one of the supported MinistryPlatform tables.
  • Partial Failures: If Continue On Fail is enabled, the node will return error messages per item instead of stopping execution. Review these messages to identify problematic records.

Links and References

Discussion