Can an N/Query RESTlet use the same field names as a REST query?
I have a select statement that searches for Purchase Orders using the REST API. Can I use the same select statement in an N/Query RESTLet? For example, here is my select statement:
{
“sql”: “SELECT t.id AS Internalid, t.TranDisplayName, t.tranid, t.status, t.tosubsidiary AS subsidiary, t.trandate, t.entity, v.entityid AS vendorname, t.custbody_edi_vendor AS IsVendor, v.representingsubsidiary, t.otherrefnum, t.location, t.shippingaddress, Shipping.addressee, Shipping.attention, t.custbody_bc_edi_status, t.custbody_edi_account, t.custbody_edi_997_accept, t.custbody_edi_997_reject, t.custbody_edi_shipping_code, t.custbody_ship_blind, t.custbody_ship_complete, tl.item AS ItemID, tl.Rate, tl.NetAmount, tl.Quantity, tl.custcol_custom_item_name, tl.custcol_bci_display_name, tl.custcol3 AS VendorPO FROM TransactionLine AS tl INNER JOIN Transaction AS t ON t.id = tl.Transaction LEFT OUTER JOIN transactionShippingAddress AS Shipping ON Shipping.nkey = t.shippingaddress LEFT OUTER JOIN Vendor AS v ON t.entity = v.id WHERE t.type = ‘PurchOrd’ AND t.custbody_bc_edi_status=’1′ AND t.custbody_edi_997_accept=’F’ AND (t.entity=’2351′ OR t.entity=’2851′) AND (t.status!=’H’ AND t.status!=’C’ AND t.status!=’A’) AND t.custbody_edi_vendor=’T’ AND tl.Item IS NOT NULL AND tl.taxline=’F'”
}
My concern is that REST uses the Connect Browser field names. Should the RESTLet query use the Schema Browser field names? My WHERE clause won’t work if we need to use Schema Browser field names since there are no fields such as NKEY and ID in the NetSuite objects. Any help is greatly appreciated. Thanks.