​

Configuring F360 as a Source

​

1. Add account access

• Token Login: The API token for F360. Obtain this from the F360 platform when creating a public API webservice. The JWT token will be obtained automatically via login.
• Start Date: (Required for some streams) The earliest date from which records will be synced (YYYY-MM-DD). Required by notas, parcelas_titulos, parcelas_titulos_despesa, parcelas_titulos_receita, parcelas_titulos_despesa_aberto, parcelas_titulos_receita_aberto, parcelas_cartoes, and extrato_bancario streams.

​

2. Select streams

Tip: The stream can be found more easily by typing its name.

​

3. Configure data streams

• Layer: choose between the existing layers on your catalog. This is where you will find your new extracted tables as the extraction runs successfully.
• Folder: a folder can be created inside the selected layer to group all tables being created from this new data source.
• Table name: we suggest a name, but feel free to customize it. You have the option to add a prefix to all tables at once 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

• Configure Delta Log Retention and determine for how long we should store old states of this table as it gets updated. Read more about this resource here.
• Determine when to execute an Additional Full Sync. This will complement the incremental data extractions, ensuring that your data is completely synchronized with your source every once in a while.

​

5. Check your new source

​

Streams and Fields

​

Data Model

​

Use Cases for Data Analysis

​

1. Bank Reconciliation Overview

• Identify unreconciled transactions
• Monitor cash flow by account
• Verify bank statement accuracy

SELECT
   conta,
   data,
   COUNT(*) AS transaction_count,
   SUM(valor) AS total_value,
   SUM(CASE WHEN valor > 0 THEN valor ELSE 0 END) AS credits,
   SUM(CASE WHEN valor < 0 THEN valor ELSE 0 END) AS debits
FROM
   nekt_raw.f360_extrato_bancario
WHERE
   data >= CURRENT_DATE - INTERVAL '30' DAY
GROUP BY
   conta,
   data
ORDER BY
   conta,
   data DESC

SELECT
   conta,
   data,
   COUNT(*) AS transaction_count,
   SUM(valor) AS total_value,
   SUM(CASE WHEN valor > 0 THEN valor ELSE 0 END) AS credits,
   SUM(CASE WHEN valor < 0 THEN valor ELSE 0 END) AS debits
FROM
   `nekt_raw.f360_extrato_bancario`
WHERE
   DATE(data) >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY
   conta,
   data
ORDER BY
   conta,
   data DESC

​

2. Revenue and Expense Summary by Type

• Understand revenue vs expense breakdown
• Track cash flow by transaction type
• Support budget vs. actual analysis

SELECT
   tipo,
   LEFT(liquidacao, 7) AS month,
   COUNT(*) AS transaction_count,
   SUM(valor_liquido) AS total_value
FROM
   nekt_raw.f360_parcelas_titulos
WHERE
   liquidacao IS NOT NULL
   AND liquidacao != ''
   AND cancelada = false
GROUP BY
   tipo,
   LEFT(liquidacao, 7)
ORDER BY
   month DESC,
   total_value DESC

SELECT
   tipo,
   SUBSTR(liquidacao, 1, 7) AS month,
   COUNT(*) AS transaction_count,
   SUM(valor_liquido) AS total_value
FROM
   `nekt_raw.f360_parcelas_titulos`
WHERE
   liquidacao IS NOT NULL
   AND liquidacao != ''
   AND cancelada = false
GROUP BY
   tipo,
   SUBSTR(liquidacao, 1, 7)
ORDER BY
   month DESC,
   total_value DESC

​

Implementation Notes

​

Data Quality Considerations

• The Extrato Bancário stream automatically deduplicates records; the API may return the same transaction across pagination boundaries.
• Start Date is required for streams that use date windows: notas, parcelas_titulos, parcelas_titulos_despesa, parcelas_titulos_receita, parcelas_titulos_despesa_aberto, parcelas_titulos_receita_aberto, parcelas_cartoes, and extrato_bancario.
• The open installment streams (Parcelas de Títulos - Despesa em Aberto and Parcelas de Títulos - Receita em Aberto) fetch data up to 2 years in the future to capture upcoming receivables and payables.
• Extrato Bancário is a child stream of Contas Bancárias; it fetches transaction data per bank account.

​

API Limits & Performance

• For faster extractions, select only the streams necessary for your analysis.
• Streams with incremental sync or date-based fetching (notas, parcelas_titulos, parcelas_titulos_despesa, parcelas_titulos_receita, parcelas_titulos_despesa_aberto, parcelas_titulos_receita_aberto, parcelas_cartoes) use start_date to filter data.
• The extrato_bancario stream uses 30-day date windows for efficient API requests.

​

Skills for agents