3.37Transforming Salesforce query results

Suppose Salesforce Query returns records conceptually like:

[
  {
    "Id": "001ABC",
    "Name": "Acme Corporation",
    "BillingCity": "Orlando",
    "BillingState": "FL"
  }
]

Your API should return:

{
  "customerId": "001ABC",
  "companyName": "Acme Corporation",
  "address": {
    "city": "Orlando",
    "state": "FL"
  }
}

DataWeave:

%dw 2.0
output application/json

var account = payload[0]

---
{
    customerId: account.Id,
    companyName: account.Name,

    address: {
        city: account.BillingCity,
        state: account.BillingState
    }
}

So mapping goes both directions:

API → Salesforce

Salesforce → API