Qbdtentityidmapping

The QbdtEntityIdMapping API is designed to provide access to the reference table that maps unique identifiers for database attributes that have been converted from QuickBooks Desktop to QuickBooks Online. Using this tool, developers can seamlessly migrate customers from QuickBooks Desktop to QuickBooks Online and still retain access to all the individual targets stored in the original company database.

The API can be used to obtain a full list of IDs for a particular entity type, or a specific entity, if the ID is known. Examples of each are shown below.

This mapping API is only applicable for apps using the QuickBooks XML SDK; companies taking advantage of Intuit Data Services cannot make use of this feature.

Supported Operations

Sparse

Query X

Business Rules

None.

QbdtEntityIdMapping Attributes

Attributes

Data Type Description QboEntityId String The entity identifier used in QuickBooks Online. QbdtExportableId String The entity identifier used in QuickBooks Desktop. QboEntityType String The entity type in QuickBooks Online. QbdtEntityType String The entity type in QuickBooks Desktop.

Sample Requests and Responses

Querying a QbdtEntityIdMapping

Sample Query Request

Click here for SQL requests

select * from QbdtEntityIdMapping where qbdtEntityType=’TERM’ |

select * from QbdtEntityIdMapping where qbdtEntityType=’TERM’ and qbdtExportableId=’80000004-1424241304’ |

Sample Query Response Click here to view XML

<QueryResponse> |

<QbdtEntityIdMapping> |

<QboEntityId>25</qboEntityId>                                                                                                                                                                                                                                                                        |
<QbdtExportableId>80000004-1424241304</qbdtExportableId>                                                                                                                                                                                                                                             |
<QboEntityType>TERM</qboEntityType>                                                                                                                                                                                                                                                                  |
<QbdtEntityType>TERM</qbdtEntityType>                                                                                                                                                                                                                                                                |

</QbdtEntityIdMapping> |

<QbdtEntityIdMapping> |

<QboEntityId>26</qboEntityId>                                                                                                                                                                                                                                                                        |
<QbdtExportableId>80000004-1424241305</qbdtExportableId>                                                                                                                                                                                                                                             |
<QboEntityType>TERM</qboEntityType>                                                                                                                                                                                                                                                                  |
<QbdtEntityType>TERM</qbdtEntityType>                                                                                                                                                                                                                                                                |

</QbdtEntityIdMapping> |

</QueryResponse> |

<QueryResponse> |

<QbdtEntityIdMapping>                                                                                                                                                                                                                                                                                 |
<QboEntityId>25</qboEntityId>                                                                                                                                                                                                                                                                         |
<QbdtExportableId>80000004-1424241304</qbdtExportableId>                                                                                                                                                                                                                                              |
<QboEntityType>TERM</qboEntityType>                                                                                                                                                                                                                                                                   |
<QbdtEntityType>TERM</qbdtEntityType>                                                                                                                                                                                                                                                                 |
</QbdtEntityIdMapping>                                                                                                                                                                                                                                                                                |

</QueryResponse> |