Easy JSON Feed - without module

[wbmnfktr]

$restaurants = $pages->findRaw("template=restaurant", ['id', 'title', 'modified']);
$json = json_encode(['restaurants' => array_values($restaurants)]);

Moved this from here - to keep the other thread clean:

So... yeah that little script does a really good job.
While I read about findRaw() somewhere I never really cared somehow. Maybe because I haven't looked that deep into it.

It does an amazing job but for a ready to use JSON feed in an external site/app/ssg parts are missing - for me.
Text and textarea fields are fine and easy to use somewhere else.

PageReferences are slightly different and need a slightly different subfield request with, otherwise you would just receive the IDs:
'myPageReferenceFieldMultiple.title'

"myPageReferenceFieldMultiple": {
  "7009": {
  "title": "Voucher"
  },
  "7010": {
  "title": "Dinner"
  },
  "7011": {
  "title": "Outdoor"
  },
  "7012": {
  "title": "Vegan offers"
  },
  "7013": {
  "title": "Take away"
  },
  "8574": {
  "title": "Special offers"
  }
},

Image fields really only have the raw data. No url, no image details, nothing.

"myImageFieldSingle": [
  {
    "data": "logo.png",
    "sort": "0",
    "description": "",
    "modified": "2020-04-16 18:59:33",
    "created": "2020-04-16 18:59:33",
    "filedata": "",
    "filesize": null,
    "created_users_id": "0",
    "modified_users_id": "0",
    "width": null,
    "height": null,
    "ratio": null
  }
],

And repeater matrix fields are yet another animal. Similar to repeater fields but more complicated to get each and every matrix entry and its details.

"myRepeaterMatrixField": {
  "data": "8577,7060,7360,6443,6415,6414",
  "count": "6",
  "parent_id": "6399"
}

 

Amazing... so far.

Ping at @bernhard @kongondo

[kongondo]

1 hour ago, wbmnfktr said:

PageReferences are slightly different and need a slightly different subfield request with, otherwise you would just receive the IDs:
'myPageReferenceFieldMultiple.title'

Yes. There are these alternatives though:

Quote

// You can also use this format below to get multiple subfields from one field: $a = $pages->findRaw("template=blog", [ "title", "categories" => [ "id", "title" ] ]);

☝️this has never worked for me though. Will at best return an empty array and at worst throw a SQL error.

1 hour ago, wbmnfktr said:

Image fields really only have the raw data. No url, no image details, nothing.

Works fine for me, except for URL. I get  ratio, width, etc.

 

https://processwire.com/api/ref/pages/find-raw/

Edited February 23, 2022 by kongondo

[wbmnfktr]

18 minutes ago, kongondo said:

☝️this has never worked for me though. Will at best return an empty array and at worst throw a SQL error.

It's the same here.

18 minutes ago, kongondo said:

Works fine for me, except for URL. I get  ratio, width, etc.

Oh... that's interesting. I tried my query on all of my pages and... some now return details, yet I don't know what's happening. It didn't bother me in the past so I just might ignore it for the moment.

 

20 minutes ago, kongondo said:

https://processwire.com/api/ref/pages/find-raw/

That's were I was looking right now.

[bernhard]

Well... what you are discovering is exactly why I built RockFinder. The first version was built before findRaw existed but I'm still using the current version RockFinder3 for RockGrid because it does all the things you mentioned properly with an easy to use syntax.

[wbmnfktr]

So maybe I have to play with RockFinder3 a bit even before trying AppApi.

To be honest I would never ever have thought about using it just because it feels way overhead for "just a JSON feed".

So... I will cherry-pick in that docs and maybe find a way to get the results I need.

[bernhard]

Or you use RockHeadless ?  Referencing to the other post...

 

 

[adrian]

8 hours ago, kongondo said:

☝️this has never worked for me though. Will at best return an empty array and at worst throw a SQL error.

Is this the issue? https://github.com/processwire/processwire-issues/issues/1511 - if so, it is fixed now.

[adrian]

Have you guys tried combining findRaw() with url hooks - https://processwire.com/blog/posts/pw-3.0.173/ ? I find it a really easy way to take care of this stuff.  

[kongondo]

5 hours ago, adrian said:

Have you guys tried combining findRaw() with url hooks - https://processwire.com/blog/posts/pw-3.0.173/ ? I find it a really easy way to take care of this stuff.  

Yep. Padloper2 ?.

[kongondo]

5 hours ago, adrian said:

Is this the issue? https://github.com/processwire/processwire-issues/issues/1511 - if so, it is fixed now.

Quite likely.

[wbmnfktr]

It works in 3.0.194.

Good tip!

[rick]

Just tossin' more info in the thread...

https://github.com/salsify/jsonstreamingparser

https://www.jsonfeed.org/version/1.1/

 

 

[elabx]

Just stumbled into this package and reminded me of this discussion, thought it might be worth dumping it here, maybe the goals it means to solve resonate with the ideas exchanged here:

https://fractal.thephpleague.com/