Introduction
This article guides you through retrieving information efficiently when you have multiple URLs or paths with similar data structures. By using the UNION all URLs with a single dataset approach, you can return responses from all URLs in one step.
Prerequisites
- SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from the Customer Download Area or get the trial version.
Steps
-
Add a Data Flow task to your SSIS package.
-
Inside the Data Flow, add a Source component. In this case, we will use the JSON source component.
-
Enable the option Enable Multi URL/Path Mode.
-
In the first example, we will use two different file paths separated by a double colon
(::). For instance:
C:\Users\DELL\OneDrive - ZappySys\Escritorio\test\JSONs\books1.json::C:\Users\DELL\OneDrive - ZappySys\Escritorio\test\database\books2.json
Here is the result:
-
In the second example, we will use three different URLs separated by a double colon
(::). For example:https://jsonplaceholder.typicode.com/todos/4::https://jsonplaceholder.typicode.com/todos/1::https://jsonplaceholder.typicode.com/todos/2
Here is the result:
-
Test the examples and save the configuration by clicking OK.
Conclusion
Following these steps, you can read multiple URLs/paths with only one component with a similar structure. For assistance or inquiries, contact our support team via chat on our website or through email at support@zappysys.com.
Reference
For more detailed information, refer to our JSON source article.