@memberjunction/connector-propfuel@1.2.0
Minor Changes
-
991a336: Fix the seed migration so
mj app installsucceeds — the migration now creates the connector's CredentialType before the Integration.These connectors define their own
MJ: Credential Typesrow (e.g.PropFuel API,GrowthZone OAuth2,Salesforce JWT Bearer) and theirIntegrationrow references it viaCredentialTypeID. The published migration seeded theIntegrationbut never created the CredentialType, so every fresh install aborted at the migration step (which runs before any metadata sync) with:The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Integration_CredentialType" (SQL Server) function __mj.spCreateIntegration(...) — FK_Integration_CredentialType (PostgreSQL)Root cause was in the seed-migration generator: it reset the
Integration/IntegrationObject/IntegrationObjectFieldcatalog between connectors but left CredentialType rows in the generation DB, somj sync push's SQL-logging saw the type already present and emitted nospCreateCredentialTypecall. Fixed the generator to also delete each connector's own CredentialType before its push, so the create is re-emitted; the existingdirectoryOrder(credential-type before integration) places it ahead of the Integration in the migration.Verified: each connector's regenerated migration applies cleanly against a real
__mjschema (realFK_Integration_CredentialType+spCreate*functions) — CredentialType created, then Integration, then objects, 0 errors. Both SQL Server and PostgreSQL migrations regenerated; same migration version (in place).Connectors that reference a core credential type (
OAuth2 Client Credentials,Azure Service Principal,API Key,OAuth2 Password Grant) are unaffected and unchanged — those types exist on every fresh instance.The
spCreateCredentialTypecall is also guarded withIF NOT EXISTS(both dialects), so installing two connectors that share a credential type (Fonteva and Salesforce both useSalesforce JWT Bearer) on the same instance no longer collides — the second install skips the already-created type. Verified: Salesforce-then-Fonteva on one instance, both Integrations created, 0 errors.