# 2 - Database Mapping

This step let you build a translation layer that permit the agent to properly retrieve data from a source and send it to the destination without the need to use the exact same database columns and HubSpot properties names.

Every row can be enabled/disabled using the toggle at the start of the row. When the toggle is OFF, the specific property or database column will be ignored when the data will be sent to the destination.

The central and core drop-down menus representing the database column and the HubSpot object property.

<mark style="color:orange;background-color:orange;">**IMPORTANT**</mark>: In case of HubSpot Drop-Down property make sure every internal value share the same value of the database data or it will return an error when the software will try to send data to HubSpot. For instance: if you have a drop-down property with values "lorem", "ipsum", "dolor" but in the database you have a different value or the same value but with different cases (like "Lorem"), the software will not save/update that record on HubSpot at all.

**\[Only for Database -> HubSpot operations] :** At the end of the row, is present a file checkbox. If it's checked the database column selected the software will read the data (file path or blob), upload the  file to HubSpot media and associate the media as attachment to the created/updated object.\
When the checkbox is checked, the HubSpot property is automatically disabled.

<figure><img src="/files/8iOkznW4xQOEZoqXYclp" alt=""><figcaption></figcaption></figure>

{% embed url="<https://www.youtube.com/watch?v=S6QBV1eVon4&t=327s>" %}
Database Mapping
{% endembed %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.erpbridge.io/the-operation/2-database-mapping.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.