Flowlu Tables
The provider models the data in API into a list of tables that can be queried using standard SQL statements.
Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
Flowlu Tables
| Name | Description |
| AgileCategories | Retrieve the list of agile categories. |
| AgileIssueTypesProjects | Retrieve the list of agile issue types and project relations. |
| AgileProjects | Retrieve all agile projects. |
| AgileStages | Retrieve the list of agile stages. |
| AgileTags | Retrieve the list of agile tags. |
| AgileTagsIssues | Retrieve the tag and issue relation. |
| AgileWorkflows | Retrieve the list of agile workflows. |
| BankAccounts | Retrieve the list of bank accounts. |
| Calendars | Retrieve the list of calendars. |
| Collaborators | Retrieve the list of collaborators. |
| CrmAccountCategories | Retrieve the list of crm account categories. |
| CrmAccountIndustries | Retrieve the list of crm account industries. |
| CrmAccounts | Retrieve the list of crm accounts. |
| CrmEmails | Retrieve the list of crm emails. |
| CrmLossReasons | Retrieve the list of crm loss reasons. |
| CrmOpportunities | Retrieve the list of crm opportunities (leads). |
| CrmOpportunitySources | Retrieve the list of crm opportunity sources. |
| CrmOpportunityStages | Retrieve the list of crm opportunity stages. |
| CrmPhones | Retrieve the list of crm phone numbers. |
| CrmRelations | Retrieve the list of crm relations. |
| CrmSaleFunnels | Retrieve the list of crm sale funnels. |
| CustomerPayments | Retrieve the list of customer payments. |
| EstimateContacts | Retrieve the list of estimate contacts. |
| EstimatedExpenses | Retrieve the list of estimated expenses. |
| EstimatedRevenues | Retrieve the list of estimated revenues. |
| EstimateItems | Retrieve the list of estimate items. |
| Estimates | Retrieve the list of estimates. |
| EstimateTemplates | Retrieve the list of estimate templates. |
| Followers | Retrieve the list of followers. |
| InvoiceContacts | Retrieve the list of invoice contacts. |
| InvoiceItems | Retrieve the list of invoice items. |
| Invoices | Retrieve the list of invoices. |
| IssueRelationNames | Retrieve the list of issue relation names. |
| IssueRelations | Retrieve the list of issue relations. |
| IssueRelationTypes | Retrieve the list of issue relation types. |
| Issues | Retrieve the list of issues. |
| IssueTypes | Retrieve the list of issue types. |
| Lists | Retrieve all lists. |
| Organizations | Retrieve the list of finance organizations. |
| ProductCategories | Retrieve the list of product catagories. |
| ProductManufacturers | Retrieve the list of product manufacturers. |
| ProductPriceLists | Retrieve the list of product price lists. |
| Products | Retrieve the list of products. |
| Projects | Retrieve the list of projects. |
| ProjectStages | Retrieve the list of project stages. |
| ProjectTemplates | Retrieve the list of project templates. |
| ProjectUsers | Retrieve all projects users. |
| RecurringInvoices | Retrieve the list of recurring invoices. |
| Sprints | Retrieve all sprints. |
| StageMilestones | Retrieve the list of stage milestones. |
| Tasks | Retrieve the list of tasks. |
| TasksLists | Retrieve all taskslists. |
| TaskWorkflows | Retrieve the list of task workflows. |
| TaskWorkflowStatuses | Retrieve the list of task workflow statuses. |
| Timelogs | Retrieve the list of timelogs. |
| Timesheets | Retrieve the list of timesheets. |
| Transactions | Retrieve the list of transactions. |