Join 2 API Server Connect Results

I have a GET request Server Connect API Action

https://xxxxxxxxxxx/myorderlist

which returns the following

{
  "myOrders": {
    "status": 200,
    "data": {
      "$totalResults": 3,
      "$resources": [
        {
          "$key": 3,
          "recordid": 3,
          "userid": 1,
          "name": "Test 1",
          "amount": 109872
        },
        {
          "$key": 4,
          "recordid": 4,
          "userid": 3,
          "name": "Test 2",
          "amount": 20000
        },
        {
          "$key": 10,
          "recordid": 10,
          "userid": 7,
          "name": "Test 3",
          "amount": 25000
        }
      ]
    }
  }
}

In order for me to present the data (In a Chart)
I need to set the label to be the users name rather than the ID
The name details are in a separate call by sending the ID in the URL (β€˜userid’)

https://xxxxxxxxxxx/myuser(β€˜1’).
which returns

{
  "$key": 1,
  "userid": 1,
  "first": "System",
  "last": "Manager",
  "emailaddress": "system.manager@email.com"
}

At the moment I am just getting the orderlist
But I need to then get the user details and end up with order data including the users details.

Thanks in advance

This has to be a weird co-incidence. :sweat_smile:
Take a look at this: Combine API data with Database data

1 Like