Chilkat Online Tools

DataFlex / Coupa Postman Collection - OAuth - Master / Update a Requisition in Draft Status and Submit for Approval

Back to Collection Items

Use ChilkatAx-9.5.0-win32.pkg

Procedure Test
    Handle hoHttp
    Boolean iSuccess
    Handle hoXml
    Variant vSbRequestBody
    Handle hoSbRequestBody
    Variant vResp
    Handle hoResp
    String sTemp1
    Integer iTemp1
    Boolean bTemp1

    // This example assumes the Chilkat API to have been previously unlocked.
    // See Global Unlock Sample for sample code.

    Get Create (RefClass(cComChilkatHttp)) To hoHttp
    If (Not(IsComObjectCreated(hoHttp))) Begin
        Send CreateComObject of hoHttp
    End

    // 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">20.00</total>
    //             <line-type>RequisitionAmountLine</line-type>
    //             <unit-price type="decimal">20.00</unit-price>
    //             <need-by-date type="dateTime">2020-05-15T00:00:00-05:00</need-by-date>
    //             <account>
    //                 <name>Dummy Segment 1 LookupValue 1-Dummy Segment 2 LookupValue 1</name>
    //                 <code>DUM_SEG_1_LV_1-DUM_SEG_2_LV_1</code>
    //                 <active type="boolean">true</active>
    //                 <segment-1>DUM_SEG_1_LV_1</segment-1>
    //                 <segment-2>DUM_SEG_2_LV_1</segment-2>
    //                 <account-type>
    //                     <id type="integer">29</id>
    //                     <created-at type="dateTime">2020-05-04T13:18:59-05:00</created-at>
    //                     <updated-at type="dateTime">2020-05-04T13:18:59-05:00</updated-at>
    //                     <name>Dummy 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>
    // 

    Get Create (RefClass(cComChilkatXml)) To hoXml
    If (Not(IsComObjectCreated(hoXml))) Begin
        Send CreateComObject of hoXml
    End
    Set ComTag Of hoXml To "requisition-header"
    Send ComUpdateChildContent To hoXml "justification" "Test"
    Send ComUpdateChildContent To hoXml "ship-to-attention" "Coupa Buyer"
    Send ComUpdateChildContent To hoXml "currency|code" "USD"
    Send ComUpdateChildContent To hoXml "requested-by|login" "CoupaSam"
    Send ComUpdateChildContent To hoXml "requested-by|email" "CoupaSam@coupa.com"
    Send ComUpdateChildContent To hoXml "ship-to-address|location-code" "DUMMYST"
    Get ComUpdateAttrAt Of hoXml "requisition-lines" True "type" "array" To iSuccess
    Get ComUpdateAttrAt Of hoXml "requisition-lines|requisition-line|id" True "type" "integer" To iSuccess
    Send ComUpdateChildContentInt To hoXml "requisition-lines|requisition-line|id" 5810
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|description" "Test"
    Get ComUpdateAttrAt Of hoXml "requisition-lines|requisition-line|line-num" True "type" "integer" To iSuccess
    Send ComUpdateChildContentInt To hoXml "requisition-lines|requisition-line|line-num" 1
    Get ComUpdateAttrAt Of hoXml "requisition-lines|requisition-line|total" True "type" "decimal" To iSuccess
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|total" "20.00"
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|line-type" "RequisitionAmountLine"
    Get ComUpdateAttrAt Of hoXml "requisition-lines|requisition-line|unit-price" True "type" "decimal" To iSuccess
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|unit-price" "20.00"
    Get ComUpdateAttrAt Of hoXml "requisition-lines|requisition-line|need-by-date" True "type" "dateTime" To iSuccess
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|need-by-date" "2020-05-15T00:00:00-05:00"
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|account|name" "Dummy Segment 1 LookupValue 1-Dummy Segment 2 LookupValue 1"
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|account|code" "DUM_SEG_1_LV_1-DUM_SEG_2_LV_1"
    Get ComUpdateAttrAt Of hoXml "requisition-lines|requisition-line|account|active" True "type" "boolean" To iSuccess
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|account|active" "true"
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|account|segment-1" "DUM_SEG_1_LV_1"
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|account|segment-2" "DUM_SEG_2_LV_1"
    Get ComUpdateAttrAt Of hoXml "requisition-lines|requisition-line|account|account-type|id" True "type" "integer" To iSuccess
    Send ComUpdateChildContentInt To hoXml "requisition-lines|requisition-line|account|account-type|id" 29
    Get ComUpdateAttrAt Of hoXml "requisition-lines|requisition-line|account|account-type|created-at" True "type" "dateTime" To iSuccess
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|account|account-type|created-at" "2020-05-04T13:18:59-05:00"
    Get ComUpdateAttrAt Of hoXml "requisition-lines|requisition-line|account|account-type|updated-at" True "type" "dateTime" To iSuccess
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|account|account-type|updated-at" "2020-05-04T13:18:59-05:00"
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|account|account-type|name" "Dummy Chart of Accounts"
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|account|account-type|currency|code" "USD"
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|currency|code" "USD"
    Send ComUpdateChildContent To hoXml "requisition-lines|requisition-line|supplier|name" "CoupaTester"
    Send ComUpdateChildContentInt To hoXml "requisition-lines|requisition-line|supplier|number" 123456

    // Adds the "Authorization: Bearer <access_token>" header.
    Set ComAuthToken Of hoHttp To "<access_token>"

    Get Create (RefClass(cComChilkatStringBuilder)) To hoSbRequestBody
    If (Not(IsComObjectCreated(hoSbRequestBody))) Begin
        Send CreateComObject of hoSbRequestBody
    End
    Get pvComObject of hoSbRequestBody to vSbRequestBody
    Get ComGetXmlSb Of hoXml vSbRequestBody To iSuccess

    Get pvComObject of hoSbRequestBody to vSbRequestBody
    Get ComPTextSb Of hoHttp "PUT" 'https://domain.com/requisitions/:id/update_and_submit_for_approval?fields=["id"]' vSbRequestBody "utf-8" "application/xml" False False To vResp
    If (IsComObject(vResp)) Begin
        Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
        Set pvComObject Of hoResp To vResp
    End
    Get ComLastMethodSuccess Of hoHttp To bTemp1
    If (bTemp1 = False) Begin
        Get ComLastErrorText Of hoHttp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get ComStatusCode Of hoResp To iTemp1
    Showln iTemp1
    Get ComBodyStr Of hoResp To sTemp1
    Showln sTemp1
    Send Destroy of hoResp


End_Procedure

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">20.00</total>
            <line-type>RequisitionAmountLine</line-type>
            <unit-price type="decimal">20.00</unit-price>
            <need-by-date type="dateTime">2020-05-15T00:00:00-05:00</need-by-date>
            <account>
                <name>Dummy Segment 1 LookupValue 1-Dummy Segment 2 LookupValue 1</name>
                <code>DUM_SEG_1_LV_1-DUM_SEG_2_LV_1</code>
                <active type="boolean">true</active>
                <segment-1>DUM_SEG_1_LV_1</segment-1>
                <segment-2>DUM_SEG_2_LV_1</segment-2>
                <account-type>
                    <id type="integer">29</id>
                    <created-at type="dateTime">2020-05-04T13:18:59-05:00</created-at>
                    <updated-at type="dateTime">2020-05-04T13:18:59-05:00</updated-at>
                    <name>Dummy 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/update_and_submit_for_approval?fields=["id"]

Postman Collection Item JSON

{
  "name": "Update a Requisition in Draft Status and Submit for Approval",
  "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\">20.00</total>\n            <line-type>RequisitionAmountLine</line-type>\n            <unit-price type=\"decimal\">20.00</unit-price>\n            <need-by-date type=\"dateTime\">2020-05-15T00:00:00-05:00</need-by-date>\n            <account>\n                <name>Dummy Segment 1 LookupValue 1-Dummy Segment 2 LookupValue 1</name>\n                <code>DUM_SEG_1_LV_1-DUM_SEG_2_LV_1</code>\n                <active type=\"boolean\">true</active>\n                <segment-1>DUM_SEG_1_LV_1</segment-1>\n                <segment-2>DUM_SEG_2_LV_1</segment-2>\n                <account-type>\n                    <id type=\"integer\">29</id>\n                    <created-at type=\"dateTime\">2020-05-04T13:18:59-05:00</created-at>\n                    <updated-at type=\"dateTime\">2020-05-04T13:18:59-05:00</updated-at>\n                    <name>Dummy 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/update_and_submit_for_approval?fields=[\"id\"]",
      "host": [
        "{{URL}}"
      ],
      "path": [
        "requisitions",
        ":id",
        "update_and_submit_for_approval"
      ],
      "query": [
        {
          "key": "fields",
          "value": "[\"id\"]"
        }
      ],
      "variable": [
        {
          "key": "id",
          "value": "4012",
          "description": "Coupa Internal Requisition Id"
        }
      ]
    }
  },
  "response": [
  ]
}