Full archive search

Hello,

I am new in using postman, I am trying to get full archive tweets, but to read them is little bit complicated like in the same page , I got user id and text without location or I got location, description , nb of followers etc… without the tweet .
Are there any additional steps that should I do it?

Moreover, to analyze the Twitter data , can I download the json file by excel file to be more organized and have all the parameters by coloumn ?

Hi @spacecraft-observer2 - welcome to the Postman Community! We’re glad to have you here.

What params are you adding? Have you seen Twitter’s public workspace yet? That might help you get on the right direction. In their Search Tweets folder, the full-archive search request seems useful and relevant too.

Yes I checked it. I am adding the following parameters : query, start time, end time, tweets fields and user fields. But the problem is that at first I got author_id and tweet then at the end I got his location and nb of followers , is there any way to get same below each other? or get them by table format more organized?

Moreover, to analyze the Twitter data , can I download the json file by excel file to be more organized and have all the parameters by coloumn ?

Thanks for your help.

Here’s a bit about exporting collections - you can definitely download the body response as a JSON file. Looks like Microsoft has some documentation around importing JSON files into Excel here and there are a few JSON to CSV converters I’ve found (but personally haven’t used) here. Hopefully you’d be able to organize your Excel file once the JSON file is imported.

(If anyone else reading this knows of a better way, I’d love to learn too!)

Can you send a screenshot of what you mean about getting locations and numbers of followers below each other? I’m not sure what you mean by getting the same below each other.

As for getting the results by a table format for easier organization, the Visualizer feature is your best bet. The docs here are pretty robust.

1 Like

Thank you so much for your useful response.I will try these options and come back to you if I would face any additional issues.

1 Like

Awesome! Hope it’s been working for you. If there’s anything you’ve learned that could be useful to other people reading this, I’d love to hear about it :slight_smile: