Back to Collection Items
IncludeFile "CkStringBuilder.pb"
IncludeFile "CkHttp.pb"
IncludeFile "CkHttpResponse.pb"
IncludeFile "CkXml.pb"
Procedure ChilkatExample()
; This example assumes the Chilkat API to have been previously unlocked.
; See Global Unlock Sample for sample code.
http.i = CkHttp::ckCreate()
If http.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
success.i
; 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"?>
; <requisition-header>
; <justification>Test</justification>
; <ship-to-attention>Coupa Buyer</ship-to-attention>
; <currency>
; <code>USD</code>
; </currency>
; <requested-by>
; <login>CoupaSam</login>
; <email>CoupaSam@coupa.com</email>
; </requested-by>
; <ship-to-address>
; <location-code>DUMMYST</location-code>
; </ship-to-address>
; <requisition-lines type="array">
; <requisition-line>
; <id type="integer">5810</id>
; <description>Test</description>
; <line-num type="integer">1</line-num>
; <total type="decimal">10.00</total>
; <line-type>RequisitionAmountLine</line-type>
; <unit-price type="decimal">10.00</unit-price>
; <need-by-date type="dateTime">2020-05-15T00:00:00-05:00</need-by-date>
; <account>
; <code>DUM_SEG_1_LV_1-DUM_SEG_2_LV_1</code>
; <active type="boolean">true</active>
; <segment-1>DUM2_SEG_1_LV_1</segment-1>
; <segment-2>DUM2_SEG_2_LV_2</segment-2>
; <account-type>
; <name>Dummy 2 Chart of Accounts</name>
; <currency>
; <code>USD</code>
; </currency>
; </account-type>
; </account>
; <currency>
; <code>USD</code>
; </currency>
; <supplier>
; <name>CoupaTester</name>
; <number>123456</number>
; </supplier>
; </requisition-line>
; </requisition-lines>
; </requisition-header>
;
xml.i = CkXml::ckCreate()
If xml.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkXml::setCkTag(xml, "requisition-header")
CkXml::ckUpdateChildContent(xml,"justification","Test")
CkXml::ckUpdateChildContent(xml,"ship-to-attention","Coupa Buyer")
CkXml::ckUpdateChildContent(xml,"currency|code","USD")
CkXml::ckUpdateChildContent(xml,"requested-by|login","CoupaSam")
CkXml::ckUpdateChildContent(xml,"requested-by|email","CoupaSam@coupa.com")
CkXml::ckUpdateChildContent(xml,"ship-to-address|location-code","DUMMYST")
CkXml::ckUpdateAttrAt(xml,"requisition-lines",1,"type","array")
CkXml::ckUpdateAttrAt(xml,"requisition-lines|requisition-line|id",1,"type","integer")
CkXml::ckUpdateChildContentInt(xml,"requisition-lines|requisition-line|id",5810)
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|description","Test")
CkXml::ckUpdateAttrAt(xml,"requisition-lines|requisition-line|line-num",1,"type","integer")
CkXml::ckUpdateChildContentInt(xml,"requisition-lines|requisition-line|line-num",1)
CkXml::ckUpdateAttrAt(xml,"requisition-lines|requisition-line|total",1,"type","decimal")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|total","10.00")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|line-type","RequisitionAmountLine")
CkXml::ckUpdateAttrAt(xml,"requisition-lines|requisition-line|unit-price",1,"type","decimal")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|unit-price","10.00")
CkXml::ckUpdateAttrAt(xml,"requisition-lines|requisition-line|need-by-date",1,"type","dateTime")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|need-by-date","2020-05-15T00:00:00-05:00")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|account|code","DUM_SEG_1_LV_1-DUM_SEG_2_LV_1")
CkXml::ckUpdateAttrAt(xml,"requisition-lines|requisition-line|account|active",1,"type","boolean")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|account|active","true")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|account|segment-1","DUM2_SEG_1_LV_1")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|account|segment-2","DUM2_SEG_2_LV_2")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|account|account-type|name","Dummy 2 Chart of Accounts")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|account|account-type|currency|code","USD")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|currency|code","USD")
CkXml::ckUpdateChildContent(xml,"requisition-lines|requisition-line|supplier|name","CoupaTester")
CkXml::ckUpdateChildContentInt(xml,"requisition-lines|requisition-line|supplier|number",123456)
; Adds the "Authorization: Bearer <access_token>" header.
CkHttp::setCkAuthToken(http, "<access_token>")
sbRequestBody.i = CkStringBuilder::ckCreate()
If sbRequestBody.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkXml::ckGetXmlSb(xml,sbRequestBody)
resp.i = CkHttp::ckPTextSb(http,"PUT","https://domain.com/requisitions/:id?fields=[" + Chr(34) + "id" + Chr(34) + "]",sbRequestBody,"utf-8","application/xml",0,0)
If CkHttp::ckLastMethodSuccess(http) = 0
Debug CkHttp::ckLastErrorText(http)
CkHttp::ckDispose(http)
CkXml::ckDispose(xml)
CkStringBuilder::ckDispose(sbRequestBody)
ProcedureReturn
EndIf
Debug Str(CkHttpResponse::ckStatusCode(resp))
Debug CkHttpResponse::ckBodyStr(resp)
CkHttpResponse::ckDispose(resp)
CkHttp::ckDispose(http)
CkXml::ckDispose(xml)
CkStringBuilder::ckDispose(sbRequestBody)
ProcedureReturn
EndProcedure
Curl Command
curl -X PUT
-H "Authorization: Bearer <access_token>"
-d '<?xml version="1.0" encoding="UTF-8"?>
<requisition-header>
<justification>Test</justification>
<ship-to-attention>Coupa Buyer</ship-to-attention>
<currency>
<code>USD</code>
</currency>
<requested-by>
<login>CoupaSam</login>
<email>CoupaSam@coupa.com</email>
</requested-by>
<ship-to-address>
<location-code>DUMMYST</location-code>
</ship-to-address>
<requisition-lines type="array">
<requisition-line>
<id type="integer">5810</id>
<description>Test</description>
<line-num type="integer">1</line-num>
<total type="decimal">10.00</total>
<line-type>RequisitionAmountLine</line-type>
<unit-price type="decimal">10.00</unit-price>
<need-by-date type="dateTime">2020-05-15T00:00:00-05:00</need-by-date>
<account>
<code>DUM_SEG_1_LV_1-DUM_SEG_2_LV_1</code>
<active type="boolean">true</active>
<segment-1>DUM2_SEG_1_LV_1</segment-1>
<segment-2>DUM2_SEG_2_LV_2</segment-2>
<account-type>
<name>Dummy 2 Chart of Accounts</name>
<currency>
<code>USD</code>
</currency>
</account-type>
</account>
<currency>
<code>USD</code>
</currency>
<supplier>
<name>CoupaTester</name>
<number>123456</number>
</supplier>
</requisition-line>
</requisition-lines>
</requisition-header>'
https://domain.com/requisitions/:id?fields=["id"]
Postman Collection Item JSON
{
"name": "Update a Requisition COA in Pending Approval Status",
"request": {
"method": "PUT",
"header": [
],
"body": {
"mode": "raw",
"raw": "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<requisition-header>\n <justification>Test</justification>\n <ship-to-attention>Coupa Buyer</ship-to-attention>\n <currency>\n <code>USD</code>\n </currency>\n <requested-by>\n <login>CoupaSam</login>\n <email>CoupaSam@coupa.com</email>\n </requested-by>\n <ship-to-address>\n <location-code>DUMMYST</location-code>\n </ship-to-address>\n <requisition-lines type=\"array\">\n <requisition-line>\n \t<id type=\"integer\">5810</id>\n <description>Test</description>\n <line-num type=\"integer\">1</line-num>\n <total type=\"decimal\">10.00</total>\n <line-type>RequisitionAmountLine</line-type>\n <unit-price type=\"decimal\">10.00</unit-price>\n <need-by-date type=\"dateTime\">2020-05-15T00:00:00-05:00</need-by-date>\n <account>\n <code>DUM_SEG_1_LV_1-DUM_SEG_2_LV_1</code>\n <active type=\"boolean\">true</active>\n <segment-1>DUM2_SEG_1_LV_1</segment-1>\n <segment-2>DUM2_SEG_2_LV_2</segment-2>\n <account-type>\n <name>Dummy 2 Chart of Accounts</name>\n <currency>\n <code>USD</code>\n </currency>\n </account-type>\n </account>\n <currency>\n <code>USD</code>\n </currency>\n <supplier>\n <name>CoupaTester</name>\n <number>123456</number>\n </supplier>\n </requisition-line>\n </requisition-lines>\n</requisition-header>",
"options": {
"raw": {
"language": "xml"
}
}
},
"url": {
"raw": "{{URL}}/requisitions/:id?fields=[\"id\"]",
"host": [
"{{URL}}"
],
"path": [
"requisitions",
":id"
],
"query": [
{
"key": "fields",
"value": "[\"id\"]"
}
],
"variable": [
{
"key": "id",
"value": "3645",
"description": "Coupa Internal Requisition Id"
}
]
},
"description": "While updating the COA, keep the field \"code\" as the old billing string and use the fields \"segments\" to update it to new values"
},
"response": [
]
}
