This reference is for integrators. It describes what iPaaS.com moves from your staging environment to production when your integration is promoted, whether it is being created in production for the first time or updated from an existing production version.

Once the move completes, you can modify anything in your production account directly. Fields noted as preserved on update are intentionally left untouched in production so that changes you have already made there are not overwritten.

Some field and table names shown below (for example, those prefixed with ST_ or TM_) are the internal iPaaS.com database identifiers for each item. They are included so you can match an entry to the underlying object it represents.

What Gets Moved

Integration (Core Record)

Field	Created	Updated	Notes
Name	Yes	Yes
ApiVersion	Yes	Yes
Description	Yes	Conditional	Only overwrites empty existing values
ImageUrl	Yes	No	Preserved from target on update; blob-storage URL constraints apply (must be at ipaasimages.blob.core.windows.net on PROD)
SystemTypeAuthorizationId	Yes	No	Preserved from target on update

Not moved (top-level ST_SystemType fields):

OwnedByCompanyId — resolved implicitly via the API token used for the call (see OwnedBy company parameter feature)
Designation — not included
Categories (ST_IntegrationCategoryAssignment list) — not part of the move
CreatedBy, CreatedDateTime, UpdatedBy, UpdatedDateTime — set on the target side
IsActive

Version

Field	Created	Updated	Notes
Name	Yes	Yes
DllName	Yes	Yes
DllNamespace	Yes	Yes
VersionMajor	Yes	Yes
VersionMinor	Yes	Yes
VersionPatch	No	Yes
ReleaseNotes	Yes	Conditional	Only overwrites empty existing values
OAuthIdentifierField	Yes	Yes
OAuthSuccessCallbackField	Yes	Yes
OAuthUrlTemplate	Yes	Yes
CustomFields (Key, Value, AvailableInApi)	Yes	No	On update, existing target custom fields are preserved (they are generally environment specific). On create, source custom fields are copied.

Marketing Info

Field	Created	Updated	Notes
Title	Yes	Conditional	Only overwrites empty existing values
Summary	Yes	Conditional	Only overwrites empty existing values
Description	Yes	Conditional	Only overwrites empty existing values
VideoURL	Yes	Conditional	Only overwrites empty existing values
UserDocumentationURL	Yes	Conditional	Only overwrites empty existing values
Features	Yes	Yes
ImageURLs	Yes	Yes
CaseStudies	Yes	Yes
CategoryIds	Yes	Yes
ApplicationId	Yes	Yes
PriceDescription	Yes	Conditional	Only overwrites empty existing values
PriceInitial	Yes	Conditional	Only overwrites empty existing values
PriceMonthly	Yes	Conditional	Only overwrites empty existing values
VersionIds	Yes	Yes
TechnicalOverview	Yes	Conditional	Only overwrites empty existing values
InstallationInstructions	Yes	Conditional	Only overwrites empty existing values
APIUpdateInformation	N/A	Preserved	Preserved from target; not sourced from the source integration

Feature Support

Field	Created	Updated	Notes
MappingCollectionType	Yes	Yes
MappingDirectionId	Yes	Yes
Support	Yes	Conditional	Only overwrites empty existing values
AdditionalInformation	Yes	Conditional	Only overwrites empty existing values
AllowInitialization	Yes	No	Preserved from target on update
CollisionHandlingSupported	Yes	Yes
CustomFieldSupported	Yes	Yes
IndependentTransferSupported	Yes	Yes
PollingSupported	Yes	Yes
RecordMatchingSupported	Yes	Yes
ExternalWebhookSupportId	Yes	Yes
SupportedMethods	Yes	Yes
EndpointsUtilized	Yes	Yes
ExternalIdFormats	Yes	Yes
ExternalDataTypes	Yes	Yes

Tables & Fields

Per Table:

Field	Moved	Notes
Name	Yes
Description	Yes
FriendlyName (PrettyName)	Yes
MappingCollectionTypeId	Yes

Per Field (nested under each table):

Field	Moved	Notes
Name	Yes
Description	Yes
Required (IsRequired)	Yes
Type (Datatype)	Yes
FieldValues (Value, Description)	Yes

Only active records are moved.

Presets

Field	Moved	Notes
Name	Yes
DataType	Yes
IsRequired	Yes
DefaultValue	Yes
SortOrder	Yes
FieldValues (Value, Description)	Yes

Scopes

Field	Moved	Notes
Name	Yes
Description	Yes
MappingCollectionTypeId	Yes
ScopeActionId	Yes

Not moved:

Webhook scopes (names starting with webhook/scope/) — created automatically when the system type is created
Scopes with MappingCollectionTypeId == 0

Webhook Configurations

Field	Moved	Notes
SystemTypeId	Yes
URLPath	Yes
BodyPreprocessingExpression	Yes
HasMultiple	Yes
MultipleSelector_JsonPath	Yes
FieldDefinitions[]	Yes	Each with: ValueName, RetrievalType, RetrievalValue, ProcessingType, ProcessingValue

Template Custom Fields

Template custom fields are moved.

Template Translation Collections

Field	Moved	Notes
Collection Name	Yes
CollectionTypeId	Yes
Translations[]	Yes

Template Mapping Collections

Field	Moved	Notes
Collection Name	Yes
CollectionTypeId	Yes
MappingRequests[]	Yes

Data NOT Moved

The following integration-related data must be migrated manually or set up in production after the move:

Data	Why Not Moved
OwnedByCompanyId	Set implicitly by the API token used (see OwnedBy company parameter)
Designation	Not included in the move
Categories / Category Assignments	`ST_IntegrationCategoryAssignment` list is not part of the move
Version Custom Fields (on update)	Deliberately preserved from target — considered environment-specific
ImageUrl (on update)	Preserved from target — blob-storage URL domain restrictions on PROD
SystemTypeAuthorizationId (on update)	Preserved from target
AllowInitialization (on update)	Preserved from target on feature-support updates
Marketing APIUpdateInformation	Preserved from target, not sourced from source integration
Audit fields (CreatedBy, CreatedDateTime, UpdatedBy, UpdatedDateTime)	Set automatically by the target
Webhook scopes	Auto-created by the system
Scopes with MappingCollectionTypeId = 0	Not moved

Move Integration: Data Reference