Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
-- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
-- Use this online tool to generate code from sample XML: Generate Code to Create XML
-- The following XML is sent in the request body.
-- <?xml version="1.0" encoding="UTF-8"?>
-- <supplier-information>
-- <supplier-id>3537</supplier-id>
-- <status>approved</status>
-- <name>SIM load33</name>
-- <display-name>SIM Display Load33</display-name>
-- <federal-tax-num>534567891</federal-tax-num>
-- <duns-number>534567810</duns-number>
-- <invoice-matching-level>2-way</invoice-matching-level>
-- <estimated-spend-amount>0.0</estimated-spend-amount>
-- <user-id>2</user-id>
-- <po-email>load1sims@test.com</po-email>
-- <po-method>email</po-method>
-- <last-exported-at/>
-- <po-change-method>email</po-change-method>
-- <content-groups>
-- <content-group>
-- <name>CG1</name>
-- </content-group>
-- <content-group>
-- <name>CG2</name>
-- </content-group>
-- </content-groups>
-- <supplier-information-addresses>
-- <kind>Primary</kind>
-- <location-code>lcload11</location-code>
-- <address-name>addname11</address-name>
-- <street-address>street 1</street-address>
-- <street-address2>st 2</street-address2>
-- <postal-code>23415</postal-code>
-- <city>Reno</city>
-- <state-region>NV</state-region>
-- <active>true</active>
-- <country>
-- <code>US</code>
-- </country>
-- </supplier-information-addresses>
-- <supplier-information-addresses>
-- <kind>RTA</kind>
-- <location-code>rtas1</location-code>
-- <address-name>IDK1</address-name>
-- <street-address>1 st bank</street-address>
-- <street-address2/>
-- <postal-code>23541</postal-code>
-- <city>Princeton</city>
-- <state-region>NJ</state-region>
-- <active>true</active>
-- <country>
-- <code>US</code>
-- </country>
-- <bank-address>maybe st 1</bank-address>
-- <bank-city>Princeton</bank-city>
-- <bank-state-region>NJ</bank-state-region>
-- <bank-postal-code>23541</bank-postal-code>
-- <name-on-bank-account>My Name</name-on-bank-account>
-- <bank-name>Wells Fargo</bank-name>
-- <bank-account-number>2345678901</bank-account-number>
-- <bank-routing-number>234123234</bank-routing-number>
-- <international-bank-account-number/>
-- <iban-number/>
-- <sort-code/>
-- <swift-code/>
-- <bic/>
-- </supplier-information-addresses>
-- <supplier-information-addresses>
-- <kind>RTA</kind>
-- <location-code>2loca234</location-code>
-- <address-name/>
-- <street-address>1 test st</street-address>
-- <street-address2/>
-- <postal-code>23412</postal-code>
-- <city>San Mateo</city>
-- <state-region>CA</state-region>
-- <active>true</active>
-- <country>
-- <code>US</code>
-- </country>
-- <bank-address>END Of The rd</bank-address>
-- <bank-city>San Mateo</bank-city>
-- <bank-state-region>CA</bank-state-region>
-- <bank-postal-code>25342</bank-postal-code>
-- <name-on-bank-account>My Name</name-on-bank-account>
-- <bank-name>Wells Fargo</bank-name>
-- <bank-account-number>546755654323</bank-account-number>
-- <bank-routing-number>100002341</bank-routing-number>
-- <international-bank-account-number/>
-- <iban-number/>
-- <sort-code/>
-- <swift-code/>
-- <bic/>
-- </supplier-information-addresses>
-- <supplier-information-addresses>
-- <kind>Standard</kind>
-- <location-code>stdlcode1</location-code>
-- <address-name/>
-- <street-address>1 stnd st</street-address>
-- <street-address2/>
-- <postal-code>33231</postal-code>
-- <city>Chicago</city>
-- <state-region>IL</state-region>
-- <active>true</active>
-- <country>
-- <code>US</code>
-- </country>
-- </supplier-information-addresses>
-- <supplier-information-contacts>
-- <supplier-information-contact>
-- <kind>Primary</kind>
-- <name-given>fname1</name-given>
-- <name-family>lastn1</name-family>
-- <email>test21@rest.com</email>
-- </supplier-information-contact>
-- </supplier-information-contacts>
-- </supplier-information>
--
DECLARE @xml int
-- Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT
EXEC sp_OASetProperty @xml, 'Tag', 'supplier-information'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'supplier-id', 3537
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'status', 'approved'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'name', 'SIM load33'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'display-name', 'SIM Display Load33'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'federal-tax-num', 534567891
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'duns-number', 534567810
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'invoice-matching-level', '2-way'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'estimated-spend-amount', '0.0'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'user-id', 2
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'po-email', 'load1sims@test.com'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'po-method', 'email'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'last-exported-at', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'po-change-method', 'email'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'content-groups|content-group|name', 'CG1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'content-groups|content-group[1]|name', 'CG2'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses|kind', 'Primary'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses|location-code', 'lcload11'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses|address-name', 'addname11'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses|street-address', 'street 1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses|street-address2', 'st 2'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'supplier-information-addresses|postal-code', 23415
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses|city', 'Reno'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses|state-region', 'NV'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses|active', 'true'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses|country|code', 'US'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|kind', 'RTA'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|location-code', 'rtas1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|address-name', 'IDK1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|street-address', '1 st bank'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|street-address2', ''
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'supplier-information-addresses[1]|postal-code', 23541
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|city', 'Princeton'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|state-region', 'NJ'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|active', 'true'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|country|code', 'US'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|bank-address', 'maybe st 1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|bank-city', 'Princeton'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|bank-state-region', 'NJ'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'supplier-information-addresses[1]|bank-postal-code', 23541
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|name-on-bank-account', 'My Name'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|bank-name', 'Wells Fargo'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|bank-account-number', '2345678901'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'supplier-information-addresses[1]|bank-routing-number', 234123234
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|international-bank-account-number', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|iban-number', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|sort-code', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|swift-code', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[1]|bic', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|kind', 'RTA'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|location-code', '2loca234'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|address-name', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|street-address', '1 test st'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|street-address2', ''
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'supplier-information-addresses[2]|postal-code', 23412
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|city', 'San Mateo'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|state-region', 'CA'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|active', 'true'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|country|code', 'US'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|bank-address', 'END Of The rd'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|bank-city', 'San Mateo'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|bank-state-region', 'CA'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'supplier-information-addresses[2]|bank-postal-code', 25342
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|name-on-bank-account', 'My Name'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|bank-name', 'Wells Fargo'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|bank-account-number', '546755654323'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'supplier-information-addresses[2]|bank-routing-number', 100002341
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|international-bank-account-number', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|iban-number', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|sort-code', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|swift-code', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[2]|bic', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[3]|kind', 'Standard'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[3]|location-code', 'stdlcode1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[3]|address-name', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[3]|street-address', '1 stnd st'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[3]|street-address2', ''
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'supplier-information-addresses[3]|postal-code', 33231
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[3]|city', 'Chicago'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[3]|state-region', 'IL'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[3]|active', 'true'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-addresses[3]|country|code', 'US'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-contacts|supplier-information-contact|kind', 'Primary'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-contacts|supplier-information-contact|name-given', 'fname1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-contacts|supplier-information-contact|name-family', 'lastn1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-information-contacts|supplier-information-contact|email', 'test21@rest.com'
-- Adds the "Authorization: Bearer <access_token>" header.
EXEC sp_OASetProperty @http, 'AuthToken', '<access_token>'
DECLARE @sbRequestBody int
-- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbRequestBody OUT
EXEC sp_OAMethod @xml, 'GetXmlSb', @success OUT, @sbRequestBody
DECLARE @resp int
EXEC sp_OAMethod @http, 'PTextSb', @resp OUT, 'POST', '["id","supplier_information_id","kind","name_given","name_family","email"]}]', @sbRequestBody, 'utf-8', 'application/xml', 0, 0
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @sbRequestBody
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT @iTmp0
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @sbRequestBody
END
GO
Curl Command
curl -X POST
-H "Authorization: Bearer <access_token>"
-d '<?xml version="1.0" encoding="UTF-8"?>
<supplier-information>
<supplier-id>3537</supplier-id>
<status>approved</status>
<name>SIM load33</name>
<display-name>SIM Display Load33</display-name>
<federal-tax-num>534567891</federal-tax-num>
<duns-number>534567810</duns-number>
<invoice-matching-level>2-way</invoice-matching-level>
<estimated-spend-amount>0.0</estimated-spend-amount>
<user-id>2</user-id>
<po-email>load1sims@test.com</po-email>
<po-method>email</po-method>
<last-exported-at />
<po-change-method>email</po-change-method>
<content-groups>
<content-group>
<name>CG1</name>
</content-group>
<content-group>
<name>CG2</name>
</content-group>
</content-groups>
<supplier-information-addresses>
<kind>Primary</kind>
<location-code>lcload11</location-code>
<address-name>addname11</address-name>
<street-address>street 1</street-address>
<street-address2>st 2</street-address2>
<postal-code>23415</postal-code>
<city>Reno</city>
<state-region>NV</state-region>
<active>true</active>
<country>
<code>US</code>
</country>
</supplier-information-addresses>
<supplier-information-addresses>
<kind>RTA</kind>
<location-code>rtas1</location-code>
<address-name>IDK1</address-name>
<street-address>1 st bank</street-address>
<street-address2 />
<postal-code>23541</postal-code>
<city>Princeton</city>
<state-region>NJ</state-region>
<active>true</active>
<country>
<code>US</code>
</country>
<bank-address>maybe st 1</bank-address>
<bank-city>Princeton</bank-city>
<bank-state-region>NJ</bank-state-region>
<bank-postal-code>23541</bank-postal-code>
<name-on-bank-account>My Name</name-on-bank-account>
<bank-name>Wells Fargo</bank-name>
<bank-account-number>2345678901</bank-account-number>
<bank-routing-number>234123234</bank-routing-number>
<international-bank-account-number />
<iban-number />
<sort-code />
<swift-code />
<bic />
</supplier-information-addresses>
<supplier-information-addresses>
<kind>RTA</kind>
<location-code>2loca234</location-code>
<address-name />
<street-address>1 test st</street-address>
<street-address2 />
<postal-code>23412</postal-code>
<city>San Mateo</city>
<state-region>CA</state-region>
<active>true</active>
<country>
<code>US</code>
</country>
<bank-address>END Of The rd</bank-address>
<bank-city>San Mateo</bank-city>
<bank-state-region>CA</bank-state-region>
<bank-postal-code>25342</bank-postal-code>
<name-on-bank-account>My Name</name-on-bank-account>
<bank-name>Wells Fargo</bank-name>
<bank-account-number>546755654323</bank-account-number>
<bank-routing-number>100002341</bank-routing-number>
<international-bank-account-number />
<iban-number />
<sort-code />
<swift-code />
<bic />
</supplier-information-addresses>
<supplier-information-addresses>
<kind>Standard</kind>
<location-code>stdlcode1</location-code>
<address-name />
<street-address>1 stnd st</street-address>
<street-address2 />
<postal-code>33231</postal-code>
<city>Chicago</city>
<state-region>IL</state-region>
<active>true</active>
<country>
<code>US</code>
</country>
</supplier-information-addresses>
<supplier-information-contacts>
<supplier-information-contact>
<kind>Primary</kind>
<name-given>fname1</name-given>
<name-family>lastn1</name-family>
<email>test21@rest.com</email>
</supplier-information-contact>
</supplier-information-contacts>
</supplier-information>'
https://domain.com/supplier_information?fields=["id","status","lasy_exported_at","name","display_name","supplier_id","supplier_number","federal_tax_num","duns_number","user_id","po_email",{"custom_fields": {}},{"created_by": ["id","login","email"]},{"updated_by": ["id","login","email"]},{"supplier_information_addresses": ["id","kind","location_code","address_name","street_address","street_address2","city","postal_code","state",{"country": ["id","code","name"]},{"custom_fields": {}}]},{"supplier_information_contacts": ["id","supplier_information_id","kind","name_given","name_family","email"]}]
Postman Collection Item JSON
{
"name": "Create SIM with Primary/RTA/Standard Addresses",
"request": {
"method": "POST",
"header": [
],
"body": {
"mode": "raw",
"raw": "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<supplier-information>\n <supplier-id>3537</supplier-id>\n <status>approved</status>\n <name>SIM load33</name>\n <display-name>SIM Display Load33</display-name>\n <federal-tax-num>534567891</federal-tax-num>\n <duns-number>534567810</duns-number>\n <invoice-matching-level>2-way</invoice-matching-level>\n <estimated-spend-amount>0.0</estimated-spend-amount>\n <user-id>2</user-id>\n <po-email>load1sims@test.com</po-email>\n <po-method>email</po-method>\n <last-exported-at />\n <po-change-method>email</po-change-method>\n <content-groups>\n <content-group>\n <name>CG1</name>\n </content-group>\n <content-group>\n <name>CG2</name>\n </content-group>\n </content-groups>\n <supplier-information-addresses>\n <kind>Primary</kind>\n <location-code>lcload11</location-code>\n <address-name>addname11</address-name>\n <street-address>street 1</street-address>\n <street-address2>st 2</street-address2>\n <postal-code>23415</postal-code>\n <city>Reno</city>\n <state-region>NV</state-region>\n <active>true</active>\n <country>\n <code>US</code>\n </country>\n </supplier-information-addresses>\n <supplier-information-addresses>\n <kind>RTA</kind>\n <location-code>rtas1</location-code>\n <address-name>IDK1</address-name>\n <street-address>1 st bank</street-address>\n <street-address2 />\n <postal-code>23541</postal-code>\n <city>Princeton</city>\n <state-region>NJ</state-region>\n <active>true</active>\n <country>\n <code>US</code>\n </country>\n <bank-address>maybe st 1</bank-address>\n <bank-city>Princeton</bank-city>\n <bank-state-region>NJ</bank-state-region>\n <bank-postal-code>23541</bank-postal-code>\n <name-on-bank-account>My Name</name-on-bank-account>\n <bank-name>Wells Fargo</bank-name>\n <bank-account-number>2345678901</bank-account-number>\n <bank-routing-number>234123234</bank-routing-number>\n <international-bank-account-number />\n <iban-number />\n <sort-code />\n <swift-code />\n <bic />\n </supplier-information-addresses>\n <supplier-information-addresses>\n <kind>RTA</kind>\n <location-code>2loca234</location-code>\n <address-name />\n <street-address>1 test st</street-address>\n <street-address2 />\n <postal-code>23412</postal-code>\n <city>San Mateo</city>\n <state-region>CA</state-region>\n <active>true</active>\n <country>\n <code>US</code>\n </country>\n <bank-address>END Of The rd</bank-address>\n <bank-city>San Mateo</bank-city>\n <bank-state-region>CA</bank-state-region>\n <bank-postal-code>25342</bank-postal-code>\n <name-on-bank-account>My Name</name-on-bank-account>\n <bank-name>Wells Fargo</bank-name>\n <bank-account-number>546755654323</bank-account-number>\n <bank-routing-number>100002341</bank-routing-number>\n <international-bank-account-number />\n <iban-number />\n <sort-code />\n <swift-code />\n <bic />\n </supplier-information-addresses>\n <supplier-information-addresses>\n <kind>Standard</kind>\n <location-code>stdlcode1</location-code>\n <address-name />\n <street-address>1 stnd st</street-address>\n <street-address2 />\n <postal-code>33231</postal-code>\n <city>Chicago</city>\n <state-region>IL</state-region>\n <active>true</active>\n <country>\n <code>US</code>\n </country>\n </supplier-information-addresses>\n <supplier-information-contacts>\n <supplier-information-contact>\n <kind>Primary</kind>\n <name-given>fname1</name-given>\n <name-family>lastn1</name-family>\n <email>test21@rest.com</email>\n </supplier-information-contact>\n </supplier-information-contacts>\n</supplier-information>",
"options": {
"raw": {
"language": "xml"
}
}
},
"url": {
"raw": "{{URL}}/supplier_information?fields=[\"id\",\"status\",\"lasy_exported_at\",\"name\",\"display_name\",\"supplier_id\",\"supplier_number\",\"federal_tax_num\",\"duns_number\",\"user_id\",\"po_email\",{\"custom_fields\": {}},{\"created_by\": [\"id\",\"login\",\"email\"]},{\"updated_by\": [\"id\",\"login\",\"email\"]},{\"supplier_information_addresses\": [\"id\",\"kind\",\"location_code\",\"address_name\",\"street_address\",\"street_address2\",\"city\",\"postal_code\",\"state\",{\"country\": [\"id\",\"code\",\"name\"]},{\"custom_fields\": {}}]},{\"supplier_information_contacts\": [\"id\",\"supplier_information_id\",\"kind\",\"name_given\",\"name_family\",\"email\"]}]",
"host": [
"{{URL}}"
],
"path": [
"supplier_information"
],
"query": [
{
"key": "fields",
"value": "[\"id\",\"status\",\"lasy_exported_at\",\"name\",\"display_name\",\"supplier_id\",\"supplier_number\",\"federal_tax_num\",\"duns_number\",\"user_id\",\"po_email\",{\"custom_fields\": {}},{\"created_by\": [\"id\",\"login\",\"email\"]},{\"updated_by\": [\"id\",\"login\",\"email\"]},{\"supplier_information_addresses\": [\"id\",\"kind\",\"location_code\",\"address_name\",\"street_address\",\"street_address2\",\"city\",\"postal_code\",\"state\",{\"country\": [\"id\",\"code\",\"name\"]},{\"custom_fields\": {}}]},{\"supplier_information_contacts\": [\"id\",\"supplier_information_id\",\"kind\",\"name_given\",\"name_family\",\"email\"]}]"
}
]
}
},
"response": [
]
}
