How do I get a pipe to return a field value when not using recordID to identify the record?

App Development
1

I want to find a record by another unique identifier and I’m trying to use the “Filter by a Single Field” API call in the “Tadabase Rest API (Updated)” pipe.

The new API call filter is working and I’m correctly identifying the correct record…

correctfilterrecord
correctfilterrecord1346×422 38.5 KB

but I want to return the field “field_365”. I’ve tried modifying the response to look like this…

notreturned
notreturned1538×360 36.3 KB

but the value is presented in the response below. I’m really guessing at how to do this so any pointers would be appreciated.

{
“items”: [
{
“id”: “blNeR26Qxw”,
“field_365”: 12261,
“field_366”: 20009,
“field_367”: 63,
“field_368”: "Plymouth Yacht Haven ",
“field_369”: “2016-01-05”,
“field_370”: “”,
“field_371”: “Purfleet (”,
“field_372”: “”,
“field_373”: “”,
“field_374”: “”,
“field_375”: “12/22/2015”,
“field_376”: 4,
“field_377”: “”,
“field_378”: 1,
“field_379”: 20009,
“field_380”: “2016-01-14”,
“field_381”: 618.95,
“field_382”: 1,
“field_383”: “20”,
“field_384”: “1”,
“field_385”: 3,
“field_386”: “RETYPE WITH NO SPACINGS”,
“field_387”: 29000,
“field_388”: 4700,
“field_389”: 4950,
“field_390”: 62000,
“field_391”: “”,
“field_392”: “”,
“field_393”: “”,
“field_394”: “”,
“field_395”: “”,
“field_396”: “”,
“field_397”: “”,
“field_398”: “”,
“field_399”: 18190,
“field_400”: 4620,
“field_401”: 4890,
“field_402”: 20000,
“field_403”: “”,
“field_404”: “”,
“field_405”: “”,
“field_406”: “Boat”,
“field_407”: “4 + 2”,
“field_408”: “48969”,
“field_409”: “UK Permit & Pilot”,
“field_410”: “nico”,
“field_411”: “”,
“field_412”: "Gerard ",
“field_413”: “”,
“field_414”: “”,
“field_417”: 17,
“field_418”: “”,
“field_419”: “”,
“field_420”: “”,
“field_421”: “”,
“field_422”: “”,
“field_423”: 1,
“field_424”: “”,
“field_425”: “”,
“field_426”: “”,
“field_427”: “”,
“field_428”: “”,
“field_429”: “”,
“field_430”: “”,
“field_431”: “”,
“field_432”: “”,
“field_433”: “”,
“field_434”: “”,
“field_445”: [
“3GDN1ZmQeq”
],
“field_450”: [
“lGArg7rmR6”
],
“field_632”: “”,
“field_637”: [
“JDXQ80QYRl”
],
“field_794”: “”,
“field_795”: “”,
“field_797”: “”,
“field_798”: “”,
“field_801”: “”,
“field_804”: “”,
“field_805”: “”,
“field_822”: “”,
“field_839”: “”,
“field_934”: “”,
“field_935”: 2.55,
“field_943”: [
“DVWQWRNZ49”
],
“field_944”: “”,
“field_945”: 20,
“field_956”: 62164,
“field_1063”: “blNeR26Qxw”,
“field_415”: {
“address”: “”,
“address2”: “”,
“city”: “”,
“state”: “”,
“country”: “”,
“zip”: “”,
“lng”: “”,
“lat”: “”
},
“field_416”: {
“address”: “”,
“address2”: “”,
“city”: “”,
“state”: “”,
“country”: “”,
“zip”: “”,
“lng”: “”,
“lat”: “”
},
“field_445_val”: [
{
“id”: “3GDN1ZmQeq”,
“val”: "Van "
}
],
“field_450_val”: [
{
“id”: “lGArg7rmR6”,
“val”: “INVOICE - Paid”
}
],
“field_632_val”: ,
“field_637_val”: [
{
“id”: “JDXQ80QYRl”,
“val”: “Permit & Pilot”
}
],
“field_794_val”: ,
“field_795_val”: ,
“field_797_val”: ,
“field_798_val”: ,
“field_804_val”: ,
“field_822_val”: ,
“field_839_val”: ,
“field_943_val”: [
{
“id”: “DVWQWRNZ49”,
“val”: “GBP”
}
]
}
],
“type”: “success”,
“total_items”: 1,
“total_pages”: 1,
“current_page”: 1,
“limit”: 100

2

Hi @GREDDIE

Forgive me if the image you used was just for an example but I see your response field is items.0.field_363 and the pipe response you highlighted is items.0.field_366

3

Hi @tim.young,

The filter finds the record by specifying field_366 (JobNumber “20009”) and I wanted it to return the field_367 (Customer Number “63”) the field directly underneath in the example.

Apologies but my example showed field_363 in error.

redact
redact1521×531 52 KB

Response

response
response1496×323 34.8 KB

4

Hi @tim.young If it’s not possible to modify the Response to include a single field value how might I extract the field from the full record that is returned?

5

Hi @GREDDIE the response you mapped is correct, you’ve got it :+1:

I’m confused by the questions though, are you saying that when your run this pipe in your app, the pipe value for items.0.field_367 doesn’t work?

6

Hi @tim.young, I was expecting to see a separate response field added called CAccountResult in my Test Results.

I didn’t realise for this type for response it wouldn’t show in there, presumably because it’s an array and already included in items?

Sorry for the confusion and thanks for the support, every thing is now working as expected and I’m really pleased I’ve mastered Pipes, got them working for all sorts of API calls now.

Graham.