Import rows based on a condition

Questions & Answers
1

I am trying to import data using REST API
There are two many rows in response (and no way to send a request with my condition) , but I need only such rows which meet my condition
“log_entries”: [
{
“id”: “TRGBOPOQABO908097962”,
“type”: “TBD”,
}

so, if type == “TBD” - I want to import these rows

please, could you advise - How can I make it happen?

2

@DKostiuk

There is not much you can do in eazyBI source import configuration even if you can add custom Javascript code if there are too many rows in response.
You would need to find a way to decrease the rows in response from Rest API requrest.
Try searching that particular Rest API documentation page. Perhaps there are some filtering possibilities you can use to restrict some log_entries

Martins / eazyBI

3

I am trying to decrease the number of rows using the incremental import
Additional URL parameters:
since={{ 120 hours ago | %d-%m-%Y %H:%M:%S }}&until= {{ 119 hours ago | %d-%m-%Y %H:%M:%S }}
Additional URL parameters: Every 10 minutes

So, will it derive the date (let’s say) per hour? will it work?

4

@DKostiuk
I am affraid this “workaround” won’t help to reduce the data amount as the Incremental parameters are used after the Rest API response not during.

Martins / eazyBI

5

thank you

one more Q - The Google Sheet import doesn’t include incremental parameters, right?

6

@DKostiuk
That is the right observation. You can not use incremental imports for the google sheet source application.

Martins / eazyBI