When I login to the Goldmine system from my Asp.Net application, it is successful. However, when I try to fetch data from Contact1 table of GoldMine_New database, it gives an error. We are using the below query-
<GMAPI call="DS_Query" SessionID="1">
<data name="SQL">select contact, company, key1 from contact1 where contact=’Connie Correch’</data>
When the above query executes, it is giving me the below result-
<GMAPI SessionID="2" call="DS_Query">
<status code="0">Call did not succeed. select contact, company, key1 from contact1 where contact='Connie Correch'</status>
After logging in, when I try to insert the data with Session ID into the Contact1 table of GoldMine_New database, it gives another error. Could you please tell me if there’s anything that I am missing.