# Other functional use cases

## Using API as a data source

Ylem not only easily supports any modern database, data warehouse, or any other kind of data storage as a data source but is also very easy to use any API endpoint that returns JSON data as a data source.

To do that just configure an [API integration](https://docs.ylem.co/integrations/library-of-integrations/apis) first:

<figure><img src="https://3180830455-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FD0FT8l3QzMrw546vOdHU%2Fuploads%2FtTat7BWvglgyxGIotrlT%2FScreenshot%202022-10-09%20at%2022.52.02.png?alt=media&#x26;token=0743dd9a-f48e-45ac-bebb-9bbd42c53c8e" alt=""><figcaption><p>API integration example</p></figcaption></figure>

And then use it as a first task in the pipeline. The rest works the same way as with any other SQL-based data source.

<figure><img src="https://3180830455-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FD0FT8l3QzMrw546vOdHU%2Fuploads%2FRK1vBvrMNWGOhUWlfExt%2FScreenshot%202022-10-09%20at%2022.50.44.png?alt=media&#x26;token=387afb06-7e78-4360-a3b9-8d2f67277150" alt=""><figcaption></figcaption></figure>

## Merge data from several sources

Often you don't have all necessary data stored in one storage but rather in a few ones. For example, the ones you have in your production database that are produced by your applications and the ones stored in your CRM.

Therefore before taking any action with data, you need to use [Merge](https://docs.ylem.co/pipelines/tasks-ip/merge) task:

<figure><img src="https://3180830455-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FD0FT8l3QzMrw546vOdHU%2Fuploads%2FIz777KrRstkpqMDNC1zm%2FScreenshot%202022-10-01%20at%2019.42.20.png?alt=media&#x26;token=e959f089-b80b-40c0-b211-8b5be6b92975" alt=""><figcaption><p>Potential pipeline</p></figcaption></figure>

<figure><img src="https://3180830455-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FD0FT8l3QzMrw546vOdHU%2Fuploads%2F3CR1RE2gQwzMf5qldvjp%2FScreenshot%202022-10-01%20at%2019.42.32.png?alt=media&#x26;token=1fbbaa09-9f43-48e2-bee1-d1d7cea2fbd9" alt=""><figcaption><p>How to configure merge task</p></figcaption></figure>

## Merge data from several sources consequently

<figure><img src="https://3180830455-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FD0FT8l3QzMrw546vOdHU%2Fuploads%2FotB0L4WndACg3mioBiCQ%2FScreenshot%202022-10-01%20at%2019.54.43.png?alt=media&#x26;token=74ee1e21-ef10-4e55-8f6a-100c872db26c" alt=""><figcaption><p>Possible pipeline</p></figcaption></figure>

## Data to CSV report

<figure><img src="https://3180830455-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FD0FT8l3QzMrw546vOdHU%2Fuploads%2F9of8TAYQnU6Mw6ZFfF1J%2FScreenshot%202022-10-01%20at%2019.57.01.png?alt=media&#x26;token=cef73eaf-8c9b-461c-ac06-0cba01e82b20" alt=""><figcaption><p>Possible pipeline</p></figcaption></figure>

<figure><img src="https://3180830455-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FD0FT8l3QzMrw546vOdHU%2Fuploads%2FfqifUXCz7h0xGwUWo1mU%2FScreenshot%202022-10-01%20at%2019.57.22.png?alt=media&#x26;token=9a4985f0-128f-49e5-8190-b63fc347cc67" alt=""><figcaption><p>Transforming data to CSV report</p></figcaption></figure>

## Calling API for each entity in the dataset

<figure><img src="https://3180830455-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FD0FT8l3QzMrw546vOdHU%2Fuploads%2FmTPPZJnyFPkoHM9ApeuF%2FScreenshot%202022-10-01%20at%2019.59.44.png?alt=media&#x26;token=9762d9c6-397c-41cd-a684-35250f096d53" alt=""><figcaption></figcaption></figure>