Configuring Superlógica Assinaturas as a Source
In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the Superlógica Assinaturas option from the list of connectors. Click Next and you’ll be prompted to add your access.1. Add account access
You’ll need to provide the following credentials to connect to Superlógica Assinaturas:- App Token: The app token from Superlógica.
- Access Token: The access token from Superlógica.
The tokens are valid for 1 year, after that to continue using the APIs a new one must be generated.
2. Select streams
Choose which data streams you want to sync - you can select all streams or pick specific ones that matter most to you.Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
3. Configure data streams
Customize how you want your data to appear in your catalog. Select a name for each table (which will contain the fetched data) and the type of sync.- Table name: we suggest a name, but feel free to customize it. You have the option to add a prefix and make this process faster!
-
Sync Type: you can choose between INCREMENTAL and FULL_TABLE.
- Incremental: every time the extraction happens, we’ll get only the new data - which is good if, for example, you want to keep every record ever fetched.
- Full table: every time the extraction happens, we’ll get the current state of the data - which is good if, for example, you don’t want to have deleted data in your catalog.
4. Configure data source
Describe your data source for easy identification within your organization, not exceeding 140 characters. To define your Trigger, consider how often you want data to be extracted from this source. This decision usually depends on how frequently you need the new table data updated (every day, once a week, or only at specific times). Optionally, you can determine when to execute a full sync. This will complement the incremental data extractions, ensuring that your data is completely synchronized with your source every once in a while. Once you are ready, click Next to finalize the setup.5. Check your new source
You can view your new source on the Sources page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.For you to be able to see it on your Catalog, you need at least one successful source run.
Streams and Fields
Below you’ll find all available data streams from Superlógica Assinaturas and their corresponding fields:Clients
Clients
Stream for managing client information.Key Fields:
id_sacado_sac- Payer ID (Primary Key)st_nome_sac- Client namest_nomeref_sac- Reference namest_cgc_sac- Client CPF/CNPJst_email_sac- Client emailst_telefone_sac- Client phone
st_endereco_sac- Client addressst_complemento_sac- Address complementst_cidade_sac- Client cityst_estado_sac- Client statest_cep_sac- Client ZIP codest_bairro_sac- Neighborhoodst_pais_sac- Countryst_paisentrega_sac- Delivery countryst_numero_sac- Number
st_inscricao_sac- State registrationst_inscmunicipal_sac- Municipal registrationdt_cadastro_sac- Registration datedt_alteracao_sincro- Modification datefl_desativar_sac- Deactivate flagfl_status_sac- Client statusdt_desativacao_sac- Deactivation date
st_sexo_sac- Genderst_nacionalidade_sac- Nationalitydt_nascimento_sac- Birth datest_naturalidade_sac- Place of birthst_carteiraidentidade_sac- Identity carddt_emissaocarteira_sac- ID card issue datest_orgao_sac- Issuing agencyfl_pessoajuridica_sac- Legal entity flagfl_entidadepublica_sac- Public entity flag
st_celular_sac- Mobile phonest_fax_sac- Fax numbertx_observacao_sac- Observationstx_contatos_sac- Contacts
st_diavencimento_sac- Due dayvl_txpis_sac- PIS taxvl_txinss_sac- INSS taxvl_txirrf_sac- IRRF taxvl_txcontribuicaosocial_sac- Social contribution taxvl_txcofins_sac- COFINS taxvl_txissqn_sac- ISSQN taxvl_txdesconto_sac- Discount tax
fl_reterissqn_sac- Withhold ISSQNfl_reterpis_sac- Withhold PISfl_reterinss_sac- Withhold INSSfl_reterirrf_sac- Withhold IRRFfl_retercontribuicaosocial_sac- Withhold social contributionfl_retercofins_sac- Withhold COFINS
st_contrato_sac- Contractst_sincro_sac- Synchronizationst_codemp_sac- Company codest_senha_sac- Passwordcampo1- Custom field 1campo2- Custom field 2campo3- Custom field 3campo4- Custom field 4id_grupo_grp- Group IDst_sacadornome_sac- Drawer namest_sacadorcgc_sac- Drawer CGCst_sincroorder_sac- Synchronization order
nome_cliente- Client name (calculated)nome_formatado- Formatted name (calculated)st_nomestatus_sac- Name and status (calculated)
Assinaturas (Subscriptions)
Assinaturas (Subscriptions)
Stream for managing subscription and recurring payment information.Client Information:
id_sacado_sac- Client IDst_nome_sac- Client namest_nomeref_sac- Client reference namest_endereco_sac- Client addressst_complemento_sac- Address complementst_bairro_sac- Neighborhoodst_cidade_sac- Cityst_estado_sac- Statest_cep_sac- ZIP codest_rg_sac- RG documentst_cgc_sac- CPF/CNPJ documentst_ddd_sac- Area codest_telefone_sac- Phone numberst_email_sac- Email addressfl_status_sac- Client status
st_identificador_plc- Client plan identifierst_identificadorextra_plc- Extra identifierid_planocliente_plc- Client plan ID (Primary Key)dt_contrato_plc- Contract datedt_cancelamento_plc- Cancellation datefl_trial_plc- Trial flagdt_trialinicio_plc- Trial start datedt_trialfim_plc- Trial end datefl_autocontratar_plc- Auto contract flagfl_autorecontratar_plc- Auto renew flagfl_primeiropag_plc- First payment flagdt_primeiropag_plc- First payment date
id_plano_pla- Plan IDst_nome_pla- Plan nameid_grade_gpl- Grade IDnm_contratofim_pla- Contract end numberfl_autorecontratar_pla- Auto renew plan flagfl_autocontratar_pla- Auto contract plan flagnm_parcelas_pla- Number of installmentsst_nome_gpl- Grade name
id_mensalidade_mens- Monthly fee IDid_cliente_mens- Monthly fee client IDid_empresa_mens- Company IDst_descricao_mens- Monthly fee descriptionst_valor_mens- Monthly fee valuest_qntd_mens- Monthly fee quantitydt_atualizacao_mens- Update datedt_inicio_mens- Monthly fee start datedt_fim_mens- Monthly fee end datenm_diavencimento_mens- Monthly fee due day
fl_jan_mens- January flagfl_fev_mens- February flagfl_mar_mens- March flagfl_abr_mens- April flagfl_mai_mens- May flagfl_jun_mens- June flagfl_jul_mens- July flagfl_ago_mens- August flagfl_set_mens- September flagfl_out_mens- October flagfl_nov_mens- November flagfl_dez_mens- December flag
vl_aproxrenovacao_plc- Approximate renewal valuevl_descontorenovacao_plc- Renewal discount valuevl_txjuros_mens- Interest tax valuevl_txmulta_mens- Fine tax valuevl_txdesconto_mens- Discount tax value
st_emailindicacao_plc- Referral emailid_vendedor_for- Seller IDnm_parcelasadesao_plc- Adhesion installments numberdt_ultimarenovacao_recb- Last renewal dateid_proximarenovacao_recb- Next renewal IDid_ticket_tic- Ticket IDst_nome_cup- Coupon namest_frete_plc- Shippingid_produto_prd- Product IDid_conta_cb- Account IDid_filial_fil- Branch IDid_vendedor_mens- Seller ID monthlyid_endereco_sen- Address ID
quantidade- Quantitytotal- Total amountmrr- Monthly Recurring Revenueultimo_fim- Last end date
nome_formatado- Formatted name (calculated field)