sync_to_sql
Loads ledgers, groups, and stock items from TallyPrime into an in-memory SQL cache for fast arbitrary queries without repeated Tally access. Checks the active company to avoid stale data.
Instructions
Pull ledgers, groups, and stock items from TallyPrime into this session's SQL cache (in-memory — gone when this session ends), so query_sql can run fast arbitrary queries without hitting Tally each time. Every sync/query tool checks which company is actually open in Tally right before touching the cache and clears it if that's changed since the last one — however the switch happened (set_company, Tally's own UI, or a connector restart) — so a stale company's rows never silently answer under a new company's name; the return message says so when it happens. Does NOT sync vouchers — use sync_vouchers_to_sql for those, one date range at a time.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||