Importing, exporting, and using data in PowerShell is another essential skill. Whether you are using simple Comma-Separated Values (CSV) or you interact with RESTful APIs, PowerShell has got you covered. Many tools are able to export CSV and XML data, and management software very often exposes RESTful APIs. The following recipes will show you how to work with different types of data that you will usually encounter.
In this chapter, we will cover the following topics:
- Working with CSV
- Making objects transportable with XML
- Modern data structures – JSON and YAML
- Interacting with RESTful APIs
- Interacting with MS SQL
- Interacting with PostgreSQL and other database engines
- Encrypting data