Data Flow Release, Support for Salesforce Reports, and QuickBooks Nested Objects in Import

September 30, 2021

Skyvia Team

Meet new Skyvia update with a number of major improvements. We are glad to present you the release of our Data Flow solution, Salesforce Reports support in Data Flow, Export, and Import, and ability to map nested object fields for QuickBooks in Import.

Data Flow Release

Our Data Flow solution is out of Beta status. With it's release, we have also added the possibility to use Salesforce reports as a source in your data flows. You don't need to build a query or create an SQL SELECT statement if you have a ready Salesforce report that already returns all the necessary data.

After entering the release status, rows processed by data flows will be counted to data integration subscription limit. Since the number of success rows is defined by the user in data flow, this is not the number that will be considered for subscription limit. Instead, the new billed rows number will be available in the Result Details of each data flow run in addition to success and failed rows.

The number of billed rows is counted in the following way: we summarize the number of success rows for all the Target components that load data NOT to cache or log connections.

This change, however, won't take effect immediately. You can use Data Flow for free for another week, and we will start billing the records since October 8th, 8:00 UTC.

Salesforce Reports Support

One of the features our users asked for is support for Salesforce Reports. While Skyvia already provided tools for building queries, that return the same data as reports, so our users could achieve the same results, using a ready Salesforce report is more convenient, as you don't need to configure anything.

Now you can easily select a Salesforce report to run. This feature is available as a Source action in Data Flow, as well as in Import and Export packages. Note that in order to query data from a Salesforce report in Import and Export, the package must use new data integration runtime, and you must use advanced mode in the package tasks.

Nested Objects in QuickBooks

Skyvia team is glad to present a new feature in Skyvia Import - nested object collections support in mapping for QuickBooks. It makes import of invoices to/from QuickBooks easy, and there is no need to fiddle with JSON and other complex things. Now you can simply map fields of the nested objects in the same way as the usual fields.

Configuring Nested Object Mapping

Nested object mapping is only available for the import packages on the new data integration runtime. You need to select the Use new runtime check box. After this, in package settings, select the Nested Objects check box. After this, you can use nested objects in your mapping.

Package Editor

Nested object fields can be mapped in both directions. When nested objects are in a target object, you can map them to child source objects, queried via lookup. When they are in source, you can map them to target child objects when importing data into multiple related objects at once.

Mapping Salesforce — QuickBooks

Mapping QuickBooks — Salesforce

Current Implementation and Future Plans

Currently, this feature is implemented for QuickBooks invoices. QuickBooks is one of the most popular data sources with nested objects, and importing QuickBooks invoices is one of the most popular scenarios. However, in the near future we plan to make this feature available for other QuickBooks objects with nested object collections and other data sources.

We also have plans to support nested objects in other data integration scenarios, in addition to import.

Informative Tutorials

To get started with the new feature faster, you can read our detailed tutorials. We have prepared three tutorials for the most popular use cases — Salesforce — QuickBooks integration:

If you need to integrate your QuickBooks invoices with other data sources, you are welcome to try Skyvia! We offer a free pricing plans that allows loading 5000 records per month, and you can ask for a trial period if you need to load more records.

Try our nested objects feature and send your feedback, it will help us to make this feature even better in future!

Comments

Loading Comments