# Working with APIs & CSVs

### About this export

| Field | Value |
| --- | --- |
| **content_type** | lesson |
| **platform** | contentstack-academy |
| **source_url** | https://www.contentstack.com/academy/courses/data-insights-data-ingestion-profile-construction/data-insights-course-3--working-with-apis-csvs |
| **course_slug** | data-insights-data-ingestion-profile-construction |
| **lesson_slug** | data-insights-course-3--working-with-apis-csvs |
| **markdown_file_url** | /academy/md/courses/data-insights-data-ingestion-profile-construction/data-insights-course-3--working-with-apis-csvs.md |
| **generated_at** | 2026-11-09T09:53:49.932Z |

> Part of **[Data Ingestion & Profile Construction](https://www.contentstack.com/academy/courses/data-insights-data-ingestion-profile-construction)** on Contentstack Academy. **Academy MD v3** — structured for retrieval; no quiz or assessment keys.

<!-- ai_metadata: {"lesson_id":"07","type":"video","duration_seconds":301,"video_url":"https://cdn.jwplayer.com/previews/5OaqXTP0","thumbnail_url":"https://cdn.jwplayer.com/v2/media/5OaqXTP0/poster.jpg?width=720","topics":["Working","with","APIs","CSVs"]} -->

#### Video details

#### At a glance

- **Title:** 15-data-insights-working-with-apis-and-csvs
- **Duration:** 5m 1s
- **Media link:** https://cdn.jwplayer.com/previews/5OaqXTP0
- **Publish date (unix):** 1752876729

#### Streaming renditions

- application/vnd.apple.mpegurl
- audio/mp4 · AAC Audio · 113680 kbps
- video/mp4 · 180p · 180p · 145874 kbps
- video/mp4 · 270p · 270p · 166323 kbps
- video/mp4 · 360p · 360p · 183204 kbps
- video/mp4 · 406p · 406p · 196247 kbps
- video/mp4 · 540p · 540p · 240152 kbps
- video/mp4 · 720p · 720p · 307691 kbps
- video/mp4 · 1080p · 1080p · 506438 kbps

#### Timed text tracks (delivery)

- **thumbnails:** `https://cdn.jwplayer.com/strips/5OaqXTP0-120.vtt`

#### Video transcript

Now, I should be able to import this set of data, the CSV, to my account. There's a few different ways you can do that. There's APIs if you just want to push up the CSV. There's a number of integrations. We'll walk through how to do a Mailchimp one here in a second, so you can get a taste for it. But when I'm playing with new accounts and whatnot, one of the easiest ways is if you go to the data pipeline and you go to Streams, this little menu in the top right corner, if you click it, it'll allow you to do two things that are pretty handy. One, you can upload data to a stream, which is what we'll do. So you can just take the CSV off your computer, upload it, and push it directly to a stream. Super easy. You don't have to use the APIs. The other mechanism that could be really handy as you're learning is you can actually download an example CSV template for a stream. So it'll look at all of the different mappings that exist and generate a CSV with all the headers that you could theoretically push data into. For the default stream, there are a lot of mappings that come out of the box, so it could be a little bit confusing. But once we get our data imported, I'll do it for this new stream that we're creating, so you can see an example of what it generates. But it's a really handy tool as you're starting to play with it and get familiar with the fields and whatnot that exist. So we will upload data to the stream. We will paste in our stream name. We will upload the file, which is just sample CSV. And then you can also, we don't have a timestamp field in this data, but if you want to associate event times with the actual event time that they come in, which is important for things like purchase information or count signups, consent, whatever it may be, you can actually tell it which timestamp field to use the map. There's also a number of advanced options on controlling headers, and if you want to append data to every record, and all sorts of stuff that you can do. But in our case, we just want to upload the CSV. You hit Submit. It's going to push it to the stream. So one other important note, we call it stream stats, but our stream page is updated every two to four minutes. I think it's usually two. Sometimes it takes a little bit longer, depending on where you are in that cadence. So as soon as I do that, it's going to come back here and say, hey, there's no data yet. If we hang around for a couple of minutes, we'll see this field or this stream populate, and that data will come in. So with all of that, in theory, if we go back to our stream, so now, like I said, every two minutes, this usually updates. We gave it much longer than that. You'll see that all of the information from the CSV is now here. And then even more, in theory, if I were to go and pull, say, ARIA start, we will be able to see how good or bad my demo is. So now, you can actually see that that data was mapped up to a profile. ARIA now has an actual profile in the system. Furthermore, if I were to copy ARIA, and we'll go back to our incognito window, we'll close that. So we connected that from a CSV, a totally separate channel. If I go back to Petsy, and I click around, it just sort of builds up some profile information. I'll visit PetBeds, and then we will go back over here. And if we paste ARIA in there, so now, or even actually, I could just do this. It's even easier. If ARIA were to come to the website and sign up for the web newsletter, whatever it may be, and join that, and I go back to the profile, which is Sansa, that's ARIA, refresh it, and you should see. So now, we've associated a CSV, totally separate channel, with web data. So you can see how, as you connect multiple channels, and you have your mobile data, and your web data, and your CSV data, and your CRM data, and all these different sources, they all map up to this unified profile that's now accessible in the web layer. So you can personalize content stack-based content on the website based on email activity, or ads activity, or CRM activity, all pseudo and real-time, depending on how those systems connect. So that's kind of, for me, the best demonstration of what you start to unlock as value. There's tools that can do just the web layer. There's tools that can just do the email layer. But to be able to sort of personalize content on the website based on the email that you clicked or haven't clicked, and based on your past purchase history all in real-time, can be and should be pretty magical.

#### Key takeaways

- Connect **Working with APIs & CSVs** back to your stack configuration before moving to the next module.
- Capture one concrete artifact (screenshot, Postman call, or code snippet) that proves the step works in your environment.
- Re-read the delivery versus management boundary for anything you changed in the entry model.

## Supplement for indexing

### Content summary

Working with APIs & CSVs. Working with APIs & CSVs in Data Ingestion & Profile Construction (data-insights-data-ingestion-profile-construction).

### Retrieval tags

- Working
- with
- APIs
- CSVs
- data-insights-data-ingestion-profile-construction
- lesson 07
- Working with APIs & CSVs
- data-insights-data-ingestion-profile-construction lesson

### Indexing notes

Index this lesson as a primary chunk tagged with lesson_id "07" and topics: [Working, with, APIs, CSVs].
Parent course slug: data-insights-data-ingestion-profile-construction. Use asset_references URLs as thumbnail hints in search results when present.
Never surface LMS quiz content or assessment answers from this file.

### Asset references

| Label | URL |
| --- | --- |
| Video thumbnail: Working with APIs & CSVs | `https://cdn.jwplayer.com/v2/media/5OaqXTP0/poster.jpg?width=720` |

### External links

| Label | URL |
| --- | --- |
| Contentstack Academy home | `https://www.contentstack.com/academy/` |
| Training instance setup | `https://www.contentstack.com/academy/training-instance` |
| Academy playground (GitHub) | `https://github.com/contentstack/contentstack-academy-playground` |
| Contentstack documentation | `https://www.contentstack.com/docs/` |
