JSData & Media Start a project

← All connectors

Schema · Entity relationship diagram

GRIN tables and relationships

Creators (contacts) and their social networks, campaigns, activations, content and content stats, affiliate conversions, product-seeding orders, creator payments, products, discount codes and affiliate links.

Live12 tables · 18 relationships
ConnectPaste an API key
Default schemagrin
Source API docsgrin.stoplight.io
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
  • One table per GRIN list endpoint, with the endpoint's response fields as columns. Every table is keyed on GRIN's record id.
  • contact_orders are product-seeding shipments to creators, not store orders. Affiliate sales are in conversions.
AFFILIATE & COMMERCEcontact_networks.contact_id → contacts.idcampaigns.affiliate_link_id → affiliate_links.idcontents.activation_id → activations.idcontents.campaign_id → campaigns.idcontents.contact_id → contacts.idcontent_stats.content_id → contents.idcontent_stats.activation_id → activations.idconversions.contact_id → contacts.idconversions.discount_code_id → discount_codes.idconversions.affiliate_link_id → affiliate_links.idconversions.activation_id → activations.idcontact_orders.campaign_id → campaigns.idcontact_orders.contact_id → contacts.idcontact_payments.contact_id → contacts.idcontact_payments.campaign_id → campaigns.idcontact_payments.activation_id → activations.iddiscount_codes.contact_id → contacts.idaffiliate_links.contact_id → contacts.idcontact_orders — GET /orders (GRIN "Contact Orders"): product-seeding shipments to creators.contact_orders14id VARCHAR(64) · primary keyidvarcharcampaign_id VARCHAR(64) · → campaigns.idcampaign_idvarcharcontact_id VARCHAR(64) · → contacts.idcontact_idvarcharproduct_selection_id VARCHAR(64)product_selection_idvarcharecommerce_account_id VARCHAR(64)ecommerce_account_idvarcharcampaign_proposal_id VARCHAR(64)campaign_proposal_idvarcharuser_id VARCHAR(64)user_idvarcharexternal_order_id VARCHAR(64)external_order_idvarcharfulfillments VARCHAR(65535)fulfillmentsvarcharshipment_status VARCHAR(256)shipment_statusvarcharshipment_status_date TIMESTAMPshipment_status_datetimestampcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampproducts — GET /productsproducts20id VARCHAR(64) · primary keyidvarcharbrand_id VARCHAR(64)brand_idvarcharname VARCHAR(1024)namevarcharcost DECIMAL(18,2)costdecimalprice DECIMAL(18,2)pricedecimalimage VARCHAR(65535)imagevarcharimages VARCHAR(65535)imagesvarchardescription VARCHAR(65535)descriptionvarcharhas_options BOOLEANhas_optionsboolis_shipped BOOLEANis_shippedboolshipping_cost DECIMAL(18,2)shipping_costdecimalsku VARCHAR(256)skuvarcharexternal_id VARCHAR(64)external_idvarcharqty BIGINTqtybiginttrack_inventory BOOLEANtrack_inventorybooltrack_variant_inventory BOOLEANtrack_variant_inventoryboolcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampstatus VARCHAR(256)statusvarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampcontent_stats — GET /content-stats: latest metrics per post (refreshed in place).content_stats24id VARCHAR(64) · primary keyidvarcharcontent_id VARCHAR(64) · → contents.idcontent_idvarcharactivation_id VARCHAR(64) · → activations.idactivation_idvarcharowner_reach BIGINTowner_reachbigintimv DECIMAL(18,2)imvdecimalengagements BIGINTengagementsbigintengagement_rate DECIMAL(18,6)engagement_ratedecimalviews BIGINTviewsbigintlikes BIGINTlikesbigintcomments BIGINTcommentsbigintshares BIGINTsharesbigintinteractions BIGINTinteractionsbigintimpressions BIGINTimpressionsbigintimpressions_real BIGINTimpressions_realbigintreach BIGINTreachbigintreplies BIGINTrepliesbigintreply_rate DECIMAL(18,6)reply_ratedecimaltaps_forward BIGINTtaps_forwardbiginttaps_back BIGINTtaps_backbigintaway_swipes BIGINTaway_swipesbigintexits BIGINTexitsbigintcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampcontents — GET /content: creator posts. activation_id is the post's GRIN activation.contents15id VARCHAR(64) · primary keyidvarcharactivation_id VARCHAR(64) · → activations.idactivation_idvarcharcampaign_id VARCHAR(64) · → campaigns.idcampaign_idvarcharcontact_id VARCHAR(64) · → contacts.idcontact_idvarcharjob_id VARCHAR(64)job_idvarcharnetwork_id VARCHAR(64)network_idvarcharcontent_id VARCHAR(64)content_idvarcharcontent_rights_id VARCHAR(64)content_rights_idvarcharis_story BOOLEANis_storyboolmedia_library_content_id VARCHAR(64)media_library_content_idvarcharposted_at TIMESTAMPposted_attimestampcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampdeleted_at TIMESTAMPdeleted_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampcampaigns — GET /campaignscampaigns27id VARCHAR(64) · primary keyidvarcharaffiliate_link_id VARCHAR(64) · → affiliate_links.idaffiliate_link_idvarcharbrand_id VARCHAR(64)brand_idvarcharteam_id VARCHAR(64)team_idvarcharversion BIGINTversionbigintinternal_title VARCHAR(1024)internal_titlevarcharinfluencer_title VARCHAR(1024)influencer_titlevarcharimage VARCHAR(65535)imagevarcharbudget DECIMAL(18,2)budgetdecimaldescription VARCHAR(65535)descriptionvarcharshort_description VARCHAR(65535)short_descriptionvarchardate_proposals_start TIMESTAMPdate_proposals_starttimestampdate_proposals_end TIMESTAMPdate_proposals_endtimestampdate_content_start TIMESTAMPdate_content_starttimestampdate_content_end TIMESTAMPdate_content_endtimestampcompensation VARCHAR(65535)compensationvarchartracking_tags VARCHAR(65535)tracking_tagsvarcharpublic_tags VARCHAR(65535)public_tagsvarcharrecurring_proposals BOOLEANrecurring_proposalsbooldiscount_code_group_id VARCHAR(64)discount_code_group_idvarcharshow_revenue_tracking_information BOOLEANshow_revenue_tracking_informationboolallow_influencer_uploads BOOLEANallow_influencer_uploadsboolpayment_method VARCHAR(256)payment_methodvarcharinfluencer_inputs_price BOOLEANinfluencer_inputs_priceboolcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampaffiliate_links — GET /affiliate-contact-linksaffiliate_links12id VARCHAR(64) · primary keyidvarcharcontact_id VARCHAR(64) · → contacts.idcontact_idvarchargroup_id VARCHAR(64)group_idvarchardestination_url VARCHAR(65535)destination_urlvarcharquery_parameters VARCHAR(65535)query_parametersvarcharurl_path VARCHAR(1024)url_pathvarcharfull_url VARCHAR(65535)full_urlvarcharstart_date TIMESTAMPstart_datetimestampend_date TIMESTAMPend_datetimestampcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampcontact_networks — GET /contact-networks: a creator's connected social accounts.contact_networks27id VARCHAR(64) · primary keyidvarcharcontact_id VARCHAR(64) · → contacts.idcontact_idvarcharnetwork_id VARCHAR(64)network_idvarcharnetwork_user_id VARCHAR(64)network_user_idvarcharnetwork_url VARCHAR(65535)network_urlvarcharnetwork_username VARCHAR(1024)network_usernamevarcharnetwork_name VARCHAR(1024)network_namevarcharnetwork_account_type VARCHAR(256)network_account_typevarcharnetwork_connection_type VARCHAR(256)network_connection_typevarcharnetwork_connection_permissions VARCHAR(65535)network_connection_permissionsvarchargraph_id VARCHAR(64)graph_idvarcharreach BIGINTreachbigintavg_likes DECIMAL(20,4)avg_likesdecimalavg_comments DECIMAL(20,4)avg_commentsdecimalavg_likes_to_comment DECIMAL(20,4)avg_likes_to_commentdecimalavg_views DECIMAL(20,4)avg_viewsdecimalavg_shares DECIMAL(20,4)avg_sharesdecimalavg_engagement DECIMAL(20,4)avg_engagementdecimalavg_posts_per_day DECIMAL(20,4)avg_posts_per_daydecimalcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampstats_updated_at TIMESTAMPstats_updated_attimestampreach_updated_at TIMESTAMPreach_updated_attimestampconnection_last_checked_at TIMESTAMPconnection_last_checked_attimestampnetwork VARCHAR(256)networkvarcharprofile VARCHAR(65535)profilevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampcontacts — GET /contactscontacts32id VARCHAR(64) · primary keyidvarcharrecord_type VARCHAR(256)record_typevarcharsource VARCHAR(256)sourcevarcharowner_id VARCHAR(64)owner_idvarcharstage_id VARCHAR(64)stage_idvarcharlive_url_id VARCHAR(64)live_url_idvarcharadded_manually BOOLEANadded_manuallyboolprofile_picture VARCHAR(65535)profile_picturevarcharfirst_name VARCHAR(256)first_namevarcharlast_name VARCHAR(256)last_namevarcharemail VARCHAR(1024)emailvarcharprimary_address_id VARCHAR(64)primary_address_idvarcharphone_number VARCHAR(256)phone_numbervarcharphone_country_code VARCHAR(256)phone_country_codevarcharphone_number_display VARCHAR(256)phone_number_displayvarchargender VARCHAR(256)gendervarcharlanguage VARCHAR(256)languagevarcharcompany VARCHAR(1024)companyvarchartotal_reach BIGINTtotal_reachbigintwebsite VARCHAR(65535)websitevarcharapplication_page_id VARCHAR(64)application_page_idvarcharapplication_completed_at TIMESTAMPapplication_completed_attimestampprimary_contact_id VARCHAR(64)primary_contact_idvarcharbirthday DATEbirthdaydateis_archived BOOLEANis_archivedboolis_declined BOOLEANis_declinedboolnotification_channels VARCHAR(65535)notification_channelsvarcharcreated_at TIMESTAMPcreated_attimestampjoined_at TIMESTAMPjoined_attimestamppromoted_to_influencer_at TIMESTAMPpromoted_to_influencer_attimestampupdated_at TIMESTAMPupdated_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampcontact_payments — GET /payments (GRIN "Contact Payments").contact_payments17id VARCHAR(64) · primary keyidvarcharcontact_id VARCHAR(64) · → contacts.idcontact_idvarcharcampaign_id VARCHAR(64) · → campaigns.idcampaign_idvarcharactivation_id VARCHAR(64) · → activations.idactivation_idvarcharuser_id VARCHAR(64)user_idvarcharpayment_account_id VARCHAR(64)payment_account_idvarchartype VARCHAR(256)typevarcharamount DECIMAL(18,2)amountdecimalcurrency VARCHAR(256)currencyvarcharconversion_rate DECIMAL(18,6)conversion_ratedecimalbatch_id VARCHAR(64)batch_idvarcharstatus VARCHAR(256)statusvarcharcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampsent_at TIMESTAMPsent_attimestampdeleted_at TIMESTAMPdeleted_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampactivations — GET /activationsactivations18id VARCHAR(64) · primary keyidvarcharaccount_id VARCHAR(64)account_idvarcharbrand_id VARCHAR(64)brand_idvarcharteam_id VARCHAR(64)team_idvarcharimage VARCHAR(65535)imagevarcharname VARCHAR(1024)namevarcharpublic_name VARCHAR(1024)public_namevarchardescription VARCHAR(65535)descriptionvarchartype VARCHAR(256)typevarcharstatus VARCHAR(256)statusvarcharprevious_status VARCHAR(256)previous_statusvarcharbudget DECIMAL(18,2)budgetdecimaldollar_budget DECIMAL(18,2)dollar_budgetdecimalcurrency VARCHAR(256)currencyvarcharcurrency_rate DECIMAL(18,6)currency_ratedecimalcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampconversions — GET /conversions: affiliate / discount-code sales credited to creators.conversions22id VARCHAR(64) · primary keyidvarcharcontact_id VARCHAR(64) · → contacts.idcontact_idvarchardiscount_code_id VARCHAR(64) · → discount_codes.iddiscount_code_idvarcharaffiliate_link_id VARCHAR(64) · → affiliate_links.idaffiliate_link_idvarcharactivation_id VARCHAR(64) · → activations.idactivation_idvarcharbrand_id VARCHAR(64)brand_idvarchartype VARCHAR(256)typevarcharorder_id VARCHAR(64)order_idvarcharorder_number VARCHAR(256)order_numbervarcharamount DECIMAL(18,2)amountdecimalcommission_amount DECIMAL(18,2)commission_amountdecimalcurrency VARCHAR(256)currencyvarcharrate DECIMAL(18,6)ratedecimalmeta_data VARCHAR(65535)meta_datavarcharis_verified BOOLEANis_verifiedboolverification_status VARCHAR(256)verification_statusvarcharis_voided BOOLEANis_voidedboolvoid_reason VARCHAR(65535)void_reasonvarcharcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampvoided_at TIMESTAMPvoided_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampdiscount_codes — GET /discount-codesdiscount_codes14id VARCHAR(64) · primary keyidvarcharcontact_id VARCHAR(64) · → contacts.idcontact_idvarcharecommerce_account_id VARCHAR(64)ecommerce_account_idvarcharexternal_id VARCHAR(64)external_idvarchargroup_id VARCHAR(64)group_idvarcharcode VARCHAR(1024)codevarcharstart_date TIMESTAMPstart_datetimestampend_date TIMESTAMPend_datetimestampcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestampdisabled_at TIMESTAMPdisabled_attimestampdisabled_reason VARCHAR(1024)disabled_reasonvarchardeleted_at TIMESTAMPdeleted_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestamp
Primary keyForeign keyReferencesJoins on (not a key)

Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.

Table reference

12 tables · click a table for its columns
contacts32 columns · Creatorsshow in diagram

GET /contacts

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
record_typevarchar(256)
sourcevarchar(256)
owner_idvarchar(64)
stage_idvarchar(64)
live_url_idvarchar(64)
added_manuallyboolean
profile_picturevarchar(65535)
first_namevarchar(256)
last_namevarchar(256)
emailvarchar(1024)
primary_address_idvarchar(64)
phone_numbervarchar(256)
phone_country_codevarchar(256)
phone_number_displayvarchar(256)
gendervarchar(256)
languagevarchar(256)
companyvarchar(1024)
total_reachbigint
websitevarchar(65535)
application_page_idvarchar(64)
application_completed_attimestamp
primary_contact_idvarchar(64)
birthdaydate
is_archivedboolean
is_declinedboolean
notification_channelsvarchar(65535)
created_attimestamp
joined_attimestamp
promoted_to_influencer_attimestamp
updated_attimestamp
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
contact_networks27 columns · Creatorsshow in diagram

GET /contact-networks: a creator's connected social accounts.

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
contact_idReferences contacts.id.varchar(64)FKReferences contacts.id.
network_idvarchar(64)
network_user_idvarchar(64)
network_urlvarchar(65535)
network_usernamevarchar(1024)
network_namevarchar(1024)
network_account_typevarchar(256)
network_connection_typevarchar(256)
network_connection_permissionsvarchar(65535)
graph_idvarchar(64)
reachbigint
avg_likesdecimal(20,4)
avg_commentsdecimal(20,4)
avg_likes_to_commentdecimal(20,4)
avg_viewsdecimal(20,4)
avg_sharesdecimal(20,4)
avg_engagementdecimal(20,4)
avg_posts_per_daydecimal(20,4)
created_attimestamp
updated_attimestamp
stats_updated_attimestamp
reach_updated_attimestamp
connection_last_checked_attimestamp
networkvarchar(256)
profilevarchar(65535)
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
contact_payments17 columns · Creatorsshow in diagram

GET /payments (GRIN "Contact Payments").

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
user_idvarchar(64)
payment_account_idvarchar(64)
contact_idReferences contacts.id.varchar(64)FKReferences contacts.id.
campaign_idReferences campaigns.id.varchar(64)FKReferences campaigns.id.
typevarchar(256)
amountdecimal(18,2)
currencyvarchar(256)
conversion_ratedecimal(18,6)
batch_idvarchar(64)
statusvarchar(256)
created_attimestamp
updated_attimestamp
sent_attimestamp
deleted_attimestamp
activation_idReferences activations.id.varchar(64)FKReferences activations.id.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
campaigns27 columns · Campaigns & contentshow in diagram

GET /campaigns

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
brand_idvarchar(64)
team_idvarchar(64)
versionbigint
internal_titlevarchar(1024)
influencer_titlevarchar(1024)
imagevarchar(65535)
budgetdecimal(18,2)
descriptionvarchar(65535)
short_descriptionvarchar(65535)
date_proposals_starttimestamp
date_proposals_endtimestamp
date_content_starttimestamp
date_content_endtimestamp
compensationvarchar(65535)
tracking_tagsvarchar(65535)
public_tagsvarchar(65535)
recurring_proposalsboolean
discount_code_group_idvarchar(64)
affiliate_link_idReferences affiliate_links.id.varchar(64)FKReferences affiliate_links.id.
show_revenue_tracking_informationboolean
allow_influencer_uploadsboolean
payment_methodvarchar(256)
influencer_inputs_priceboolean
created_attimestamp
updated_attimestamp
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
activations18 columns · Campaigns & contentshow in diagram

GET /activations

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
account_idvarchar(64)
brand_idvarchar(64)
team_idvarchar(64)
imagevarchar(65535)
namevarchar(1024)
public_namevarchar(1024)
descriptionvarchar(65535)
typevarchar(256)
statusvarchar(256)
previous_statusvarchar(256)
budgetdecimal(18,2)
dollar_budgetdecimal(18,2)
currencyvarchar(256)
currency_ratedecimal(18,6)
created_attimestamp
updated_attimestamp
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
contents15 columns · Campaigns & contentshow in diagram

GET /content: creator posts. activation_id is the post's GRIN activation.

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
activation_idReferences activations.id.varchar(64)FKReferences activations.id.
campaign_idReferences campaigns.id.varchar(64)FKReferences campaigns.id.
job_idvarchar(64)
network_idvarchar(64)
contact_idReferences contacts.id.varchar(64)FKReferences contacts.id.
content_idvarchar(64)
content_rights_idvarchar(64)
is_storyboolean
media_library_content_idvarchar(64)
posted_attimestamp
created_attimestamp
updated_attimestamp
deleted_attimestamp
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
content_stats24 columns · Campaigns & contentshow in diagram

GET /content-stats: latest metrics per post (refreshed in place).

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
content_idReferences contents.id.varchar(64)FKReferences contents.id.
activation_idReferences activations.id.varchar(64)FKReferences activations.id.
owner_reachbigint
imvdecimal(18,2)
engagementsbigint
engagement_ratedecimal(18,6)
viewsbigint
likesbigint
commentsbigint
sharesbigint
interactionsbigint
impressionsbigint
impressions_realbigint
reachbigint
repliesbigint
reply_ratedecimal(18,6)
taps_forwardbigint
taps_backbigint
away_swipesbigint
exitsbigint
created_attimestamp
updated_attimestamp
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
contact_orders14 columns · Campaigns & contentshow in diagram

GRIN "Contact Orders" (GET /orders): product-seeding shipments to creators.

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
product_selection_idvarchar(64)
ecommerce_account_idvarchar(64)
campaign_idReferences campaigns.id.varchar(64)FKReferences campaigns.id.
campaign_proposal_idvarchar(64)
contact_idReferences contacts.id.varchar(64)FKReferences contacts.id.
user_idvarchar(64)
external_order_idvarchar(64)
fulfillmentsvarchar(65535)
shipment_statusvarchar(256)
shipment_status_datetimestamp
created_attimestamp
updated_attimestamp
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
conversions22 columns · Affiliate & commerceshow in diagram

GET /conversions: affiliate / discount-code sales credited to creators.

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
brand_idvarchar(64)
contact_idReferences contacts.id.varchar(64)FKReferences contacts.id.
typevarchar(256)
order_idYour store's order id for the attributed sale (not a GRIN contact order).varchar(64)Your store's order id for the attributed sale (not a GRIN contact order).
order_numbervarchar(256)
amountdecimal(18,2)
commission_amountdecimal(18,2)
currencyvarchar(256)
ratedecimal(18,6)
discount_code_idReferences discount_codes.id.varchar(64)FKReferences discount_codes.id.
affiliate_link_idReferences affiliate_links.id.varchar(64)FKReferences affiliate_links.id.
meta_datavarchar(65535)
is_verifiedboolean
verification_statusvarchar(256)
is_voidedboolean
void_reasonvarchar(65535)
created_attimestamp
updated_attimestamp
voided_attimestamp
activation_idReferences activations.id.varchar(64)FKReferences activations.id.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
products20 columns · Affiliate & commerceshow in diagram

GET /products

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
brand_idvarchar(64)
namevarchar(1024)
costdecimal(18,2)
pricedecimal(18,2)
imagevarchar(65535)
imagesvarchar(65535)
descriptionvarchar(65535)
has_optionsboolean
is_shippedboolean
shipping_costdecimal(18,2)
skuvarchar(256)
external_idvarchar(64)
qtybigint
track_inventoryboolean
track_variant_inventoryboolean
created_attimestamp
updated_attimestamp
statusvarchar(256)
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
discount_codes14 columns · Affiliate & commerceshow in diagram

GET /discount-codes

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
ecommerce_account_idvarchar(64)
external_idvarchar(64)
group_idvarchar(64)
contact_idReferences contacts.id.varchar(64)FKReferences contacts.id.
codevarchar(1024)
start_datetimestamp
end_datetimestamp
created_attimestamp
updated_attimestamp
disabled_attimestamp
disabled_reasonvarchar(1024)
deleted_attimestamp
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.

Connect GRIN All connectors