Re: MethodAPISelect_DataSetV2 and Entity Table

ITfromValor — Fri, 23 Oct 2015 15:25:16 GMT

Seems to be working! Thank you!

Re: MethodAPISelect_DataSetV2 and Entity Table

LaCrews — Fri, 23 Oct 2015 14:16:25 GMT

Try this add single quote as below

sSelectWhere = "BillAddressAddr1 ='" + house_address + "'";

MethodAPISelect_DataSetV2 and Entity Table

ITfromValor — Fri, 23 Oct 2015 13:25:59 GMT

Hi. I am trying to get a field from the Entity table so I can insert the same info into another table, but the only info I can use to search the Entity table at that point is the BillAddressAddr1, not the RecordID. If I use MethodAPISelect_DataSetV2 and the RecordID, I get the info I need, but not when I use sSelectWhere = "BillAddressAddr1 =" + house_address;

I am not sure what I am doing wrong, and I would appreciate your help.

sSelectFields = "HouseKind";
sSelectFrom = tbl; // tbl = "Entity"
sSelectWhere = "BillAddressAddr1 =" + house_address; // house_address is correct, I checked several times
sSelectGroupBy = null;
sSelectHaving = null;
sSelectOrderBy = "RecordID DESC";

//Call the MethodAPI to get the dataset
sResult = wbsMethodAPI.MethodAPISelect_DataSetV2(sCompanyAccount, sUserName, sPassword, "", ref datResponse, sSelectFrom, sSelectFields, sSelectWhere, sSelectGroupBy, sSelectHaving, sSelectOrderBy);
wbsMethodAPI = null;

Method:API Q&A

Re: MethodAPISelect_DataSetV2 and Entity Table

Re: MethodAPISelect_DataSetV2 and Entity Table

MethodAPISelect_DataSetV2 and Entity Table