MinistryPlatform icon

MinistryPlatform

Consume MinistryPlatform API for church management data operations
Join our community

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, the Table - Create operation 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 synchronize new records automatically.

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 output is a JSON array where each element corresponds to the newly created record(s) returned from the MinistryPlatform API after the creation request. Each record object contains the fields and values as stored in MinistryPlatform, including any auto-generated IDs or timestamps.

If multiple input items are processed, the output preserves the order and metadata linking each output record to its input item.

The node does not output binary data.

Dependencies

  • Requires an active connection to the MinistryPlatform API using an API key credential configured in n8n.
  • The node uses HTTP requests to communicate with MinistryPlatform endpoints.
  • Proper permissions on the MinistryPlatform account are necessary to create records in the specified tables.

Troubleshooting

  • Invalid JSON format in records:
    If the Records property contains malformed JSON or is not an array, the node will throw an error indicating invalid JSON format. Ensure that the JSON is correctly formatted and represents an array of objects.

  • API authentication errors:
    If the API key or credentials are incorrect or missing, the node will fail to authenticate. Verify that the API key credential is properly set up in n8n.

  • Permission denied or insufficient rights:
    Attempting to create records in tables without proper permissions will result in API errors. Confirm that the connected user has create access to the target table.

  • Empty or missing Table Name:
    The node requires a valid table name to function. Make sure the Table Name property is filled with a correct MinistryPlatform table.

Links and References

Discussion