סיומת מסד נתונים Google Cloud Spanner

<?xml version="1.0" encoding="UTF-8&quo>t<; standalone="yes"?
ConnectorCallout async="false" continueOnError=&quo>t;tru<e" ena>bled="true<" name=>"<;Insert-N>ew-User"
    Disp<layNameIns>ert N<ew Use>r/Disp<layName>
    <Conne><ctorspanner-users-products/Connector
    Actioninsert/Action
    Input![CDATA[{
        "tableName" : "user",
        "rows" : [{
          "username": "jonesy42",
          "firstName": "Floyd",
          "lastName": "Jones",
          "address"><;: &qu>o<t;3695 Auctor Str>eet",
          "city": "Gresham",
          "region": "OR",
          "postalCode": "12693",
          "email": "floydster@example.com"
      }]
  }]]/Input
/ConnectorCallout

<?xml version="1.0" encoding="UTF-8&quo>t<; standalone="yes"?
AssignMessage async="false" continueOnError="fa>lse&q<uot; enabled="true" name="Assign-Postal-Cod>e&quo<t;
    AssignT>o createN<ew=&>quot;true&q<uot; >transport<=&quo>t;htt<p">; typ<e="request>"<;/
    AssignVariable
   >    < Namepostal.code/Name
    > <   Valu>e86519/Value
    /AssignVariable
    IgnoreUnresolvedVariablestrue/IgnoreUnresolvedVariables
/AssignMessage

<?xml version="1.0" encoding="UTF-8&quo>t<; standalone="yes"?
ConnectorCallout async="false" continueOnError=&q>uot;t<rue" e>nabled="<true" n>ame=&<quot;Get->User-Data"
    Di<splayNameG>et Us<er Dat>a/Displa<yName
 >   Co<nnect><orspanner-users-products/Connector
    ActionquerySQL/Action
    Input![CDATA[{
      "sql" : "SELECT username, email FROM user WHERE postalCode = @postalC><ode&qu>ot;<,
    >  "params" : {
 <       >&<quot;postalCode&q>uot; : "{postal.code.value}"
      }
    }]]/Input
  Outputspanner.userdata.retrieved/Output
/ConnectorCallout

<?xml version="1.0" encoding="UTF-8&quo>t<; standalone="yes"?
AssignMessage async="false" continueOnError="false&q>uot; <enabled=&qu>ot;true" name=&quo<t;Get-Query->Respo<nse-Data"
    DisplayNameGet Query Res>ponse< Da>ta/Displa<yName
    AssignTo type="response>" createNew="false<"/
>    S<et
 > <      Payload >contentType="application/json"{spanner.userdata.retrieved}/Payload
    /Set
/AssignMessage

{
  "rows": [
    {
      "username": "freewill444",
      "email": "freewill@example.com"
    }
  ]
}

<?xml version="1.0" encoding="UTF-8&quo>t<; standalone="yes"?
ConnectorCallout async="false" continueOnError=">;true<" enab>led="true&q<uot; name=&q>uot;U<pdate-Use>r-Data"
    Displ<ayNameUpda>te Us<er Dat>a/Disp<layName>
    <Conne><ctorspanner-users-products/Connector
    Actionupdate/Action
    Input![CDATA[{
        "tableName" : "user",
        "rows&quo><t;: [{>
<            ">;username":"Liz456",
            "email":"lizzard@example.com"
        }]
    }]]/Input
/ConnectorCallout

<Action>insert</Action>
<Input><![CDATA[{
  "tableName" : "table-to-insert-into",
  "row><s">; : "rows-to-insert"
}]]/Input

<Action>insert</Action>
<Input><![CDATA[{
    "tableName" : "user",
    "rows" : [{
      "username": "jonesy42",
      "firstName": "Floyd",
      "lastName": "Jones",
      "address": "3695 Auctor Street",
      "c><ity&qu>ot;: "Gresham",
      "region": "OR",
      "postalCode": "12693",
      "email": "floydster@example.com"
  }]
}]]/Input

<Action>querySQL</Action>
<Input><![CDATA[{
  "sql" : "sql-query-statement",
  "params" : {
    &q><uot;pa>ram1" : "columnValue"
  }
}]]/Input

<Action>querySQL</Action>
<Input><![CDATA[{
  "sql" : "SELECT username, email FROM user WHERE postalCode = @postalCode",
  "params" : {
    "postalCo><de&quo>t; : "{postal.code.value}"
  }
}]]/Input

<Input><![CDATA[{
  "tableName" : "table-with-rows-to-update",
  "row><s">; : "rows-to-update"
}]]/Input

<Action>update</Action>
<Input><![CDATA[{
  "tableName" : "user",
  "rows": [{
      "username":"Liz456&q><uot;,
>      "email":"lizzard@example.com"
  }]
}]]/Input