How to load data from Asana to MongoDB

First, you need to obtain access to the Asana API. Log in to your Asana account and navigate to the "Apps" section to create a personal access token. This token will allow you to authenticate and make requests to the Asana API. Keep this token secure as it grants access to your Asana data.

Ensure you have the necessary Python libraries installed to interact with Asana's API and MongoDB. Use `pip` to install `requests` for HTTP requests to Asana and `pymongo` to interact with MongoDB. You can do this with the following commands:
```bash
pip install requests
pip install pymongo
```

Write a Python script to fetch data from Asana using the API. Use the `requests` library to send HTTP GET requests to Asana's endpoints. For example, to fetch tasks, you might use:
```python
import requests

asana_token = 'your_personal_access_token'
headers = {'Authorization': f'Bearer {asana_token}'}
response = requests.get('https://app.asana.com/api/1.0/tasks', headers=headers)

asana_data = response.json() # Process the JSON response
```

Make sure MongoDB is installed and running on your machine. You can start MongoDB by running `mongod` in your terminal. Ensure you have a database created where you want to store Asana data. You can use MongoDB's shell or GUI tools like MongoDB Compass to create a new database and collection if needed.

Use the `pymongo` library to establish a connection to your MongoDB instance. In your script, set up the connection and specify the database and collection where you want to store Asana data.
```python
from pymongo import MongoClient

client = MongoClient('mongodb://localhost:27017/')
db = client['your_database_name']
collection = db['your_collection_name']
```

Process the fetched Asana data to match the structure of your MongoDB collection. If needed, transform the data to fit your schema. Then, use the `insert_many` or `insert_one` methods from `pymongo` to insert the data into MongoDB.
```python
if 'data' in asana_data:
collection.insert_many(asana_data['data'])
else:
print("No data found in the response")
```

After the data has been moved, verify its integrity by querying the MongoDB collection to ensure all records have been transferred correctly. You can use simple queries to count documents or check specific entries.
```python
count = collection.count_documents({})
print(f"Number of documents in collection: {count}")
```
Ensure that the number of documents and data accuracy matches your expectations from the Asana source.