GrahamDavies
5 years agoQrew Member
Link to a QB record using a unique field not the Record ID?
Is it possible to create a link to a QB record using a field other than the Record ID?
I am trying to connect a different system to QB by using a unique email address for a record in QB. Ideally something very simple so that record could even ben linked from Excel without the RID:
https://target_domain/db/target_dbid?a=dr&dfid=10&query={'30'.EX.'user%40domain'}
Where field 30 is a Unique Email Address field.
When I try API_GetRecordAsHTML it requires the Record ID (Missing "rid" parameter), which I don't have in the other system.
I can use API_DoQuery with the query - but that returns XML not a link to a standard HTML form report.
Thanks!
------------------------------
Graham Davies
------------------------------
I am trying to connect a different system to QB by using a unique email address for a record in QB. Ideally something very simple so that record could even ben linked from Excel without the RID:
https://target_domain/db/target_dbid?a=dr&dfid=10&query={'30'.EX.'user%40domain'}
Where field 30 is a Unique Email Address field.
When I try API_GetRecordAsHTML it requires the Record ID (Missing "rid" parameter), which I don't have in the other system.
I can use API_DoQuery with the query - but that returns XML not a link to a standard HTML form report.
Thanks!
------------------------------
Graham Davies
------------------------------