Schema Information Upfluence
This subtopic provides a structured reference to assist you in working with Daton's Upfluence connector and the associated fields and tables.
Schema Information Upfluence
This subtopic provides a structured reference to assist you in working with Daton's Upfluence connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Typeform connector:
- Campaigns
- Contributions
- Streams
- Streams_matches
- Orders
Campaigns
This table contains information related to campaigns in the Upfluence platform. Each record corresponds to a unique campaign and contains various attributes such as campaign name, details of contributions, compensation type, and related metadata like publication briefs and payment instructions
FIELDS
Column Name |
Description |
id |
Unique identifier for the campaign |
contract_artifact_key |
Key for the contract document (if any) |
allow_conversion_download_to_creator |
Flag indicating if creators can download conversion data |
products_quantity_limit |
Maximum number of products per contribution |
brief_type |
Format of the campaign brief (e.g. text, pdf) |
brief_pdf_artifact_key |
Key for the brief PDF (if brief_type is pdf) |
name |
Name/title of the campaign |
archived |
Indicates whether the campaign is archived |
total_contributions |
Total number of contributions associated with this campaign |
owned_by |
Entity that owns the campaign (typically a company ID reference) |
publication_brief_template |
HTML template for creator publication instructions |
payment_instructions_template |
HTML template for invoice/payment instructions |
compensation_type |
Type of compensation ( payment, product, etc.) |
contribution_stats |
Object containing statistics on contributions (e.g., published count) |
created_at |
Campaign creation timestamp (ISO 8601 format) |
updated_at |
Timestamp of last update to the campaign |
logo_icon |
Optional URL or identifier for a small icon |
mailing_driver |
Email/mailing system used |
logo_url |
URL to the campaign logo |
notification_ids |
List of related notification UUIDs |
Contributions
This table contains information related to Contribution in the Upfluence platform related to each campaign. Each record corresponds to a unique campaign and contains various attributes such as ContributionID, InfluencerPrice, SellingPoint, and related metadata like publication briefs
FIELDS
Column Name |
Description |
ContributionID |
Unique identifier of the contribution |
ContractArtifactKey |
Contract file reference (if any) |
SupplierInterest |
Status of supplier’s interest |
Selectability |
Indicates how selectable the contribution is |
ClientApprovedForDrafting |
If client approved drafting |
AdminApprovedForDrafting |
If admin approved drafting |
Price |
Agreed-upon price for the collaboration |
PriceCurrency |
Currency of the price |
InfluencerPrice |
Payment to influencer |
InfluencerPriceCurrency |
Currency for influencer payment |
Comment |
Any comment added |
CreatedAt |
Contribution creation date |
UpdatedAt |
Last modification timestamp |
Slug |
URL-safe name/slug for the contribution |
PublicationURL |
URL of the published content |
SellingPoint |
Optional promotional text or focus |
VisibleByClient |
If this contribution is visible to the client |
InvitingThreadID |
Thread ID for invitation phase |
DraftingThreadID |
Thread ID for drafting |
PublishingThreadID |
Thread ID for publishing |
PaymentThreadID |
Thread ID for payments |
ShippingThreadID |
Thread ID for shipping |
SkippedShippingThread |
If shipping thread was skipped |
CurrentStatus |
Current status of the contribution |
SkippedInvitingThread |
Whether inviting phase was skipped |
SkippedDraftingThread |
Whether drafting phase was skipped |
SkippedPublishingThread |
Whether publishing phase was skipped |
SkippedPaymentThread |
Whether payment phase was skipped |
SkippedDrafting |
Whether drafting was skipped |
SkippedApplication |
Whether application step was skipped |
CampaignID |
Linked campaign ID |
RejectedByAdmin |
Whether the admin rejected the contribution |
ShippingAddress |
Address for shipping products |
CommissionRateValue |
Commission value (numeric portion) |
CommissionRateType |
Commission unit ( percent, etc.) |
UserID |
ID of the user/creator |
PaymentRequestSummaryPaidAmount |
Paid amount in cents |
PaymentRequestSummaryPaidCurrency |
Currency of paid amount |
PaymentRequestSummaryPaidCount |
Number of paid requests |
PaymentRequestSummaryPendingAmount |
Pending amount in cents |
PaymentRequestSummaryPendingCurrency |
Currency of pending amount |
PaymentRequestSummaryPendingCount |
Number of pending payment requests |
CodeProfileID |
ID of associated code profile |
SupplierID |
Supplier ID |
CompensationShippingAddressID |
ID of shipping address used for compensation |
DraftIDs |
Array of associated draft IDs |
LatestDraftID |
ID of the most recent draft |
LinkIDs |
List of associated link IDs |
NotificationIDs |
List of notification UUIDs |
PaymentRequestProxyIDs |
IDs of related payment request proxies |
ContributionProductIDs |
List of product IDs associated with contribution |
ExtraCompensationOrderIDs |
List of additional compensation IDs |
