Read

to read vendor bills, please use the below parameters supported “where” filters field name data type description datecreated long this will filter on an exact match (equal) use the “additionalfilter” option for a range of dates internalid string internal id of the vendor bill multiple values can be passed in a comma separated string lastmodifieddate long this will filter on an exact match (equal) use the “additionalfilter” option for a range of dates subsidiary string internal id of subsidiary (primary) do not use this in additonalfilter multiple ids can be passed in a comma separated string ex 1,2 additonalfilter string construct the additional filter with a combination of the above fields using ‘+and+’ separator and pass it as a single string make sure to wrap the whole string using encodingutil urlencode trandate long transaction date of the record use the “additionalfilter” option for a range of dates entity string to filter the records based on the vendor multiple ids can be passed in a comma separated string ex 6,7 example request map\<string, object> filters = new map\<string, object>(); filters put('subsidiary', '1,2'); filters put('additionalfilter', encodingutil urlencode('lastmodifieddate>1643635961+and+lastmodifieddate<1646141561', 'utf 8')); // encode additionalfilter after constructing it with +and+ for multi filters // field filters and additionalfilter for where param map\<string, object> filtermap = new map\<string, object>(); filtermap put('where', new map\<string, object>{'keyvaluemap'=>filters}); map\<string, object> requestjsonmap = new map\<string, object>(); requestjsonmap put('customparameters', filtermap); string reqjson = json serialize(requestjsonmap); map\<string, object> reqobj = new map\<string, object>(); reqobj put('version', '1 0'); reqobj put('action', 'readvendorbill); reqobj put('requestjson', reqjson); // place a request to breadwinner global api map\<string, object> resp = breadwinner ns breadwinnernetsuiteapi call(reqobj); system debug(resp); response { action=readvendorbill, responsejson={ "vendorbills" \[ { "usertotal" 25000 0, "transactionnumber" "vendbill7", "tranid" null, "trandate" 1553497200, "terms" null, "taxtotal" 0 0, "subsidiary" { "type" null, "name" "parent company", "internalid" "1", "externalid" null }, "status" "paid in full", "salesforceid" null, "nullfieldlist" null, "memo" null, "location" null, "lastmodifieddate" 1645186351, "itemlist" { "replaceall" null, "item" \[ { "unitsdisplay" null, "taxrate1" "0 0", "taxcode" { "type" null, "name" "vat in\ undef in", "internalid" "5", "externalid" null }, "tax1amt" 0 0, "shipmethod" null, "shipgroup" null, "serialnumbers" null, "revrecstartdate" null, "revrecschedule" null, "revrecenddate" null, "rate" "500 00", "quantityremaining" null, "quantityreceived" null, "quantitypicked" null, "quantitypacked" null, "quantityonhand" null, "quantityfulfilled" null, "quantitycommitted" null, "quantitybilled" null, "quantitybackordered" null, "quantityavailable" null, "quantity" 50 0, "price" null, "ponum" null, "percentcomplete" null, "orderline" 1, "onhand" null, "location" null, "line" 1, "jobname" null, "itemreceive" null, "itemname" null, "itemisfulfilled" null, "item" { "type" null, "name" "test men's vintage jeans pant", "internalid" "23", "externalid" null }, "isclosed" null, "grossamt" 25000 0, "expectedreceiptdate" null, "description" "error field 'line custcol2' not found", "department" null, "customfieldlist" null, "createpo" null, "costestimatetype" null, "costestimate" null, "classification" null, "billingschedule" null, "amount" 25000 0 } ] }, "internalid" "650", "fax" null, "externalid" null, "expenselist" null, "exchangerate" 1 0, "entity" { "type" null, "name" "test anuvarthh apparels pvt ltd", "internalid" "371", "externalid" null }, "email" null, "duedate" 1553497200, "department" null, "customform" null, "customfieldlist" { "customfield" \[ { "valuelookup" null, "value" "false", "scriptid" "custbody34", "internalid" "558", "fieldtype" null }, { "valuelookup" null, "value" "372 nikhil jain", "scriptid" "custbody breadwinner pc internal id", "internalid" "588", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custbody checkbox", "internalid" "272", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custbody edoc gen trans pdf", "internalid" "925", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custbody ei ds txn identifier", "internalid" "932", "fieldtype" null } ] }, "currencyrecord" { "type" null, "name" "inr", "internalid" "1", "externalid" null }, "currencyname" "inr", "createddate" 1553520536, "classification" null, "billingaddress" { "zip" "560011", "state" "karnataka", "internalid" "223", "country" " india", "city" "bangalore", "attention" null, "addrphone" null, "addressee" "test anuvarthh apparels pvt ltd", "addr3" null, "addr2" "jaya nagar east\tjayanagar", "addr1" "#, 108, 7th main rd, 2nd block," }, "approvalstatus" { "type" null, "name" "approved", "internalid" "2", "externalid" null } }, { "usertotal" 1 0727272727262e11, "transactionnumber" "vendbill179", "tranid" null, "trandate" 1643702400, "terms" null, "taxtotal" 1 636363636362e10, "subsidiary" { "type" null, "name" "parent company", "internalid" "1", "externalid" null }, "status" "open", "salesforceid" null, "nullfieldlist" null, "memo" null, "location" { "type" null, "name" "hyderabad hi tech city", "internalid" "10", "externalid" null }, "lastmodifieddate" 1643722367, "itemlist" { "replaceall" null, "item" \[ { "unitsdisplay" null, "taxrate1" "18 0", "taxcode" { "type" null, "name" "vat in\ gst 18", "internalid" "36", "externalid" null }, "tax1amt" 1 636363636362e10, "shipmethod" null, "shipgroup" null, "serialnumbers" null, "revrecstartdate" null, "revrecschedule" null, "revrecenddate" null, "rate" "90909090909 00", "quantityremaining" null, "quantityreceived" null, "quantitypicked" null, "quantitypacked" null, "quantityonhand" null, "quantityfulfilled" null, "quantitycommitted" null, "quantitybilled" null, "quantitybackordered" null, "quantityavailable" null, "quantity" 1 0, "price" null, "ponum" null, "percentcomplete" null, "orderline" null, "onhand" null, "location" { "type" null, "name" "hyderabad hi tech city", "internalid" "10", "externalid" null }, "line" 1, "jobname" null, "itemreceive" null, "itemname" null, "itemisfulfilled" null, "item" { "type" null, "name" "boxer", "internalid" "240", "externalid" null }, "isclosed" null, "grossamt" 1 0727272727262e11, "expectedreceiptdate" null, "description" "test desc", "department" null, "customfieldlist" { "customfield" \[ { "valuelookup" null, "value" "error field 'custcol7' not found", "scriptid" "custcol11", "internalid" "656", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custcol checkbox", "internalid" "443", "fieldtype" null } ] }, "createpo" null, "costestimatetype" null, "costestimate" null, "classification" null, "billingschedule" null, "amount" 9 0909090909e10 } ] }, "internalid" "95408", "fax" null, "externalid" null, "expenselist" null, "exchangerate" 23 0, "entity" { "type" null, "name" "11 air 1pp", "internalid" "74489", "externalid" null }, "email" null, "duedate" 1643702400, "department" null, "customform" null, "customfieldlist" { "customfield" \[ { "valuelookup" null, "value" "false", "scriptid" "custbody34", "internalid" "558", "fieldtype" null }, { "valuelookup" null, "value" " ", "scriptid" "custbody breadwinner pc internal id", "internalid" "588", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custbody checkbox", "internalid" "272", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custbody edoc gen trans pdf", "internalid" "925", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custbody ei ds txn identifier", "internalid" "932", "fieldtype" null } ] }, "currencyrecord" { "type" null, "name" "us dollars", "internalid" "2", "externalid" null }, "currencyname" "us dollars", "createddate" 1643722367, "classification" null, "billingaddress" { "zip" "505490", "state" null, "internalid" "81273", "country" " india", "city" "1", "attention" null, "addrphone" null, "addressee" "11 air 1pp", "addr3" null, "addr2" null, "addr1" "1" }, "approvalstatus" { "type" null, "name" "approved", "internalid" "2", "externalid" null } }, { "usertotal" 51 92, "transactionnumber" "vendbill180", "tranid" null, "trandate" 1644912000, "terms" null, "taxtotal" 7 92, "subsidiary" { "type" null, "name" "parent company", "internalid" "1", "externalid" null }, "status" "open", "salesforceid" null, "nullfieldlist" null, "memo" null, "location" { "type" null, "name" "test atlanta west", "internalid" "1", "externalid" null }, "lastmodifieddate" 1644922743, "itemlist" { "replaceall" null, "item" \[ { "unitsdisplay" null, "taxrate1" "18 0", "taxcode" { "type" null, "name" "vat in\ gst 18", "internalid" "36", "externalid" null }, "tax1amt" 1 8, "shipmethod" null, "shipgroup" null, "serialnumbers" null, "revrecstartdate" null, "revrecschedule" null, "revrecenddate" null, "rate" "10 00", "quantityremaining" null, "quantityreceived" null, "quantitypicked" null, "quantitypacked" null, "quantityonhand" null, "quantityfulfilled" null, "quantitycommitted" null, "quantitybilled" null, "quantitybackordered" null, "quantityavailable" null, "quantity" 1 0, "price" null, "ponum" null, "percentcomplete" null, "orderline" null, "onhand" null, "location" { "type" null, "name" "test atlanta west", "internalid" "1", "externalid" null }, "line" 1, "jobname" null, "itemreceive" null, "itemname" null, "itemisfulfilled" null, "item" { "type" null, "name" "boxer", "internalid" "240", "externalid" null }, "isclosed" null, "grossamt" 11 8, "expectedreceiptdate" null, "description" "test desc", "department" { "type" null, "name" "sales", "internalid" "2", "externalid" null }, "customfieldlist" { "customfield" \[ { "valuelookup" null, "value" "error field 'custcol7' not found", "scriptid" "custcol11", "internalid" "656", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custcol checkbox", "internalid" "443", "fieldtype" null }, { "valuelookup" null, "value" "1638950400", "scriptid" "custcol date", "internalid" "445", "fieldtype" null }, { "valuelookup" null, "value" "1639051620", "scriptid" "custcol datetime", "internalid" "447", "fieldtype" null }, { "valuelookup" null, "value" "45 3", "scriptid" "custcol decimal", "internalid" "449", "fieldtype" null }, { "valuelookup" null, "value" "10", "scriptid" "custcol integer", "internalid" "452", "fieldtype" null } ] }, "createpo" null, "costestimatetype" null, "costestimate" null, "classification" { "type" null, "name" "individual partner class", "internalid" "2", "externalid" null }, "billingschedule" null, "amount" 10 0 }, { "unitsdisplay" null, "taxrate1" "18 0", "taxcode" { "type" null, "name" "vat in\ gst 18", "internalid" "36", "externalid" null }, "tax1amt" 6 12, "shipmethod" null, "shipgroup" null, "serialnumbers" null, "revrecstartdate" null, "revrecschedule" null, "revrecenddate" null, "rate" "34 00", "quantityremaining" null, "quantityreceived" null, "quantitypicked" null, "quantitypacked" null, "quantityonhand" null, "quantityfulfilled" null, "quantitycommitted" null, "quantitybilled" null, "quantitybackordered" null, "quantityavailable" null, "quantity" 1 0, "price" null, "ponum" null, "percentcomplete" null, "orderline" null, "onhand" null, "location" { "type" null, "name" "test atlanta west", "internalid" "1", "externalid" null }, "line" 2, "jobname" null, "itemreceive" null, "itemname" null, "itemisfulfilled" null, "item" { "type" null, "name" "bow", "internalid" "239", "externalid" null }, "isclosed" null, "grossamt" 40 12, "expectedreceiptdate" null, "description" null, "department" { "type" null, "name" "sales", "internalid" "2", "externalid" null }, "customfieldlist" { "customfield" \[ { "valuelookup" null, "value" "error field 'custcol7' not found", "scriptid" "custcol11", "internalid" "656", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custcol checkbox", "internalid" "443", "fieldtype" null }, { "valuelookup" null, "value" "1644739200", "scriptid" "custcol date", "internalid" "445", "fieldtype" null }, { "valuelookup" null, "value" "1644833940", "scriptid" "custcol datetime", "internalid" "447", "fieldtype" null }, { "valuelookup" null, "value" "45 3", "scriptid" "custcol decimal", "internalid" "449", "fieldtype" null }, { "valuelookup" null, "value" "34", "scriptid" "custcol integer", "internalid" "452", "fieldtype" null } ] }, "createpo" null, "costestimatetype" null, "costestimate" null, "classification" { "type" null, "name" "individual partner class", "internalid" "2", "externalid" null }, "billingschedule" null, "amount" 34 0 } ] }, "internalid" "97609", "fax" null, "externalid" null, "expenselist" null, "exchangerate" 23 0, "entity" { "type" null, "name" "vendor rec create test 1", "internalid" "76690", "externalid" null }, "email" null, "duedate" 1644912000, "department" null, "customform" null, "customfieldlist" { "customfield" \[ { "valuelookup" null, "value" "false", "scriptid" "custbody34", "internalid" "558", "fieldtype" null }, { "valuelookup" null, "value" " ", "scriptid" "custbody breadwinner pc internal id", "internalid" "588", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custbody checkbox", "internalid" "272", "fieldtype" null }, { "valuelookup" null, "value" "1638864060", "scriptid" "custbody datetime", "internalid" "446", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custbody edoc gen trans pdf", "internalid" "925", "fieldtype" null }, { "valuelookup" null, "value" "false", "scriptid" "custbody ei ds txn identifier", "internalid" "932", "fieldtype" null }, { "valuelookup" null, "value" "10", "scriptid" "custbody integer", "internalid" "454", "fieldtype" null } ] }, "currencyrecord" { "type" null, "name" "us dollars", "internalid" "2", "externalid" null }, "currencyname" "us dollars", "createddate" 1644922743, "classification" null, "billingaddress" { "zip" "53370", "state" "6413", "internalid" "83474", "country" " india", "city" "1", "attention" null, "addrphone" null, "addressee" "vendor rec create test 1", "addr3" null, "addr2" null, "addr1" "1" }, "approvalstatus" { "type" null, "name" "approved", "internalid" "2", "externalid" null } } ], "customparamters" { "where" { "value" null, "keyvaluemap" { "subsidiary" "1,2", "additionalfilter" "lastmodifieddate%3e1643635961%2band%2blastmodifieddate%3c1646141561" } } }, "currentpagerecords" 3, "totalrecords" 3, "totalpages" 1, "searchid" "webservices 5333445 sb1 0413202320616814841383158033 85b36a5", "pageindex" 1, "errors" \[ ], "status" "200" }, timestamp=1681393897012, validrequest=true, version=1 0 }