---
title: "Automated Export / Import Process Using Web Services"
slug: "automated-export-import-process-using-web-services"
tags: ["Advancement"]
updated: 2025-04-02T18:14:42Z
published: 2025-04-02T18:14:42Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Automated Export / Import Process Using Web Services

This special advancement-focused Community Conversation focuses on setting up an automated web service in your database. Three examples explore identifying data in a query and importing the values directly back into the same database environment, enabling transformations to automatically occur on import:

- Update a pledge's status to be "fulfilled" when the amount unreceived is $0.
- Add an end date to an existing "Current Student" constituent type entity row based on a donor's conferred graduation date.
- Add a constituency type of "Alumni" as a new entity row based on the donor's conferred graduation date.

[Embedded content](https://player.vimeo.com/video/738719038)

> [!WARNING]
> **📝 Note**: This webinar instructs users to use the Force Process Import tool in a test environment to trigger a web service call. This is no longer possible in test environments, and must be done in your production environment.

## Conceptual framework

[![Conceptual Framework 1](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/8014483661595.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/8014483661595.png/Conceptual_Framework_1.png)

[![Conceptual Framework 2](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/8014505398171.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/8014505398171.png/Conceptual_Framework_2.png)

## Key takeaways

[![Conceptual Framework 2](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/8014518822171.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/8014518822171.png/Key_Takeaways.png)