Questions tagged [json]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
116 views

How to retrieve (& output via twig) one key pair of json object stored i a database column

in commerce, all transactions are written into the database, into the table "commerce_transactions". every transactions will result in a row, where different data is the stored into columns. ...
  • 329
2 votes
2 answers
215 views

PHP array missing attributes when converted to JSON

I am converting certain php data to json for use in my front end javascript. I have an array of product variants, an array of images from a media field that is defined on my variants, and an array of ...
0 votes
0 answers
34 views

Automatically encode and decode JSON saved to Element

I have a custom element with an array property, which is to be saved to the DB as JSON, and a corresponding query class: use craft\base\Element; class Foo extends Element { public array $columns; ...
  • 356
1 vote
1 answer
30 views

Jsondecode in element API causing memory issue

I have the element api pulling back 1300 entries. One of the fields is storing geojson data and I had to change the type from text to mediumtext to accommodate some of the data stored. When I moved ...
  • 1,900
1 vote
1 answer
94 views

Feed Me with Related Entries Fields - One to Many Relationship

I'm using Feed Me to populate content for a "Meetings" section in my site. One of the fields in this section is "Meeting Attendees", which is an entries field relating to a ...
  • 135
1 vote
1 answer
40 views

Feedme import formatting into Refactor from JSON

Having had a bit of a nightmare trying to get content out of Wordpress into Craft via Feedme have written an intermediary script to sanitise the WP XML export into something more palatable (JSON). ...
  • 1,731
2 votes
1 answer
80 views

Element API using the entries field to display related content from a separate section

I've seen similar questions but none seem to help. I have two sections named jobs and jobDescriptions. I'm using the entries field to pull in a description field from the jobDescriptions section to ...
  • 23
1 vote
2 answers
1k views

Twig json_decode gives Syntax Error

I'm trying to use the json_decode twig filter from Craft to decode an array of entry objects that got encoded in a macro. In the macro, the array of entry objects gets encoded by json_encode and ...
  • 305
1 vote
1 answer
198 views

Get a key value from a JSON asset in PHP

I'm using the Apple News plugin to try and display a tweet that's been added as a JSON asset in a matrix field. The JSON looks something like this { "title": "https://twitter.com/...
  • 251
1 vote
2 answers
88 views

Limiting entries object when using as json_encode

I'm building a JSON array of several thousand entries using the following entries query: {% set services = craft.entries.section('services').asArray().all() %} The problem is there some private info ...
  • 437
1 vote
1 answer
110 views

Error when trying to update Craft

I'm pretty new to CraftCMS and am trying to install updates for a client. I am getting this error and I don't really know what it means. Any help of brief explanation for this would be appreciated. ...
  • 113
1 vote
1 answer
142 views

Import JSON feed data automatically without FeedMe

Can JSON feed data be displayed in a Craft site automatically? I have a page: URL/asdfh3 I've been dynamically using 'asdfh3' to pull in data from the JSON feed that is associated with 'asdfh3'. This ...
1 vote
1 answer
2k views

Uploading Lottie animation files with images

For anyone who doesn't know what Lottie is, it is a video player created by the AirBnB team that lets you play vector animation exported from Adobe After Effects. It exports as json-files that you can ...
1 vote
1 answer
94 views

How to export Sprout Form submissions with a JSON API endpoint?

The goal is to have an endpoint that takes starting id and limit parameters and returns a filtered list of Sprout Form submissions as JSON without the JSON Feed v1 metadata bits. I've tried to set up ...
  • 387
1 vote
1 answer
86 views

Click counter for links (craft v2)

So I'm new to PHP and ok with Javascript. I have a page on my site with a long list of external links, would it be possible to add a counter to be displayed next to each link that shows how many times ...
0 votes
0 answers
197 views

Rest Controller and API Rate Limits or how to set CSRF token invalid

Problem: I have a JSON endpoint and like to limit access to it. I.e. to prevent double submits on contact forms or brute force attempts. One solution that came to my mind was rate-limiting the ...
  • 101
2 votes
0 answers
160 views

Prevent Redactor from stripping tags like <span>

Is there any possible way to prevent <span> tags from being stripped from a Redactor field? I've tried all I can using custom Redactor and HTMLPurifier configs to no avail. Basically what I'm ...
1 vote
0 answers
36 views

Serializing assets field is returning a serialized criteria object, but how to return serialized data?

I'm saving a custom element that has content by field layout. When successfully saved, I return the object in the response. Now, most of the data is usable but the assets field is just a serialized ...
  • 51
1 vote
0 answers
277 views

Entries as JSON files?

I work with VUE CLI and I want to build a entry form. My first Idea to bind in the data was props. They work but i can't modify the data (because it's props :D). To correctly integrate the data, my ...
  • 11
1 vote
1 answer
180 views

Element api JSON output formatting

I want to output all globals with one endpoint. This is trivial for the most part but I need to have some objects in a specific shape. I'm using a matrix block to handle the content. The main issue ...
1 vote
0 answers
289 views

Escaping rich text fields to json but keep html markup

I am trying to create an export from an old Craft2 site over to a new Craft3 site. The structure and fields are all different, so I figured the easiest way was to create a json file from my entries ...
  • 440
3 votes
2 answers
651 views

How to store custom data into a user

I need some direction in how to store (complex) data into users (best practice) I'm working on a project for a fitness app. I created a structure with 2 levels for workouts where level 1 entries are ...
  • 160
1 vote
1 answer
1k views

Craft 3 Plugin Controller - returnJson() replacement?

In Craft2, when making an ajax request to a plugin controller action, you would use the returnJson() method which is part of the BaseController class - which your plugin controllers extend. This sets ...
  • 917
3 votes
0 answers
357 views

JsonLD & Schema

What is the best way to use Json-LD schema in the templates for Craft 3? I would like to dynamically load parts of the info. I know about the SEOmatic plugin but looking for a way to do it on my own.
2 votes
1 answer
580 views

Getting all the values out of a field as array of values

I have a multi-select field in my work section I want to get the values either with the Element api as json or an array of simple values in my template.
3 votes
1 answer
991 views

Are there any alternatives to the deprecated Export plugin?

This thread Export Craft Data leads me to add a new question. What is a good Craft 3 export plugin? I know several for imports, for example the FeedMe plugin is doing a great job, but nothing to ...
1 vote
1 answer
515 views

When saving an Entry, I receive a JSON response rather than returning to the Entry's edit page

Craft Version: 3.0.4 Web Server: Apache + Nginx proxy Recently I've been working on a couple of Craft 3 projects for deployment on my institution's web servers. In the past, I've successfully ...
  • 137
1 vote
1 answer
337 views

FeedMe Pro Import JSON

When I import using JSON with FeedMe Pro and need to import more records into an entry that has a Matrix field. I find it deletes the previous and adds the new data only. Is there anyway to append to ...
  • 373
0 votes
1 answer
122 views

Help with FeedMe JSON

I am trying to insert records into the same entry using FeedMe with Matrix and Table for one of the fields. My table field is a plain text. So I have one programLevel, one program and a field that ...
  • 373
1 vote
1 answer
263 views

Use FeedMe with a dynamic URL

The list of entries I need to grab is available here: http://arcresources.mediaroom.com/api/newsfeed_releases/list.php?format=json Each individual entry is available at a unique URL, by adding an ID,...
  • 251
1 vote
1 answer
182 views

Using elements-api, how do i create a geojson structure with Features within a FeatureCollections

I am trying to output, from a single request, a geojson structure like so: "type": "FeatureCollection", "features": [ { "type": "Feature", "properties": {}, ...
1 vote
1 answer
586 views

Element API with multiple categories gives back error 500

This works fine on localhost but crashes on remote Server. I can return one category, but it will crash when I try to display multiple categories. I also tried to save the categories in a variable and ...
1 vote
2 answers
407 views

Querying channel entries hits memory limit

We have a channel that has about 700 entries but is paginated with a limit of 30 entries. Our client is looking to add a button so users can print out all entries. One of our proposed solutions was to ...
1 vote
2 answers
557 views

Feed Me: Valid JSON file returning as invalid

Can anyone see why this data would return as invalid in Feed Me? It's valid JSON. [ { "FIELD1":"1", "FIELD2":"Airmax", "FIELD3":"150-08ACW-134 ", "FIELD4":"...
  • 145
1 vote
1 answer
85 views

Assign User to Group While Importing on Sprout Imports

we are trying to import users into a specific group but cant figure out how the json should go. Currently we have: [ { "@model": "User", "attributes": { "username": "...
2 votes
1 answer
1k views

JQuery $.ajax ":success" form logic with Plugin Controller?

I'm working on a simple plugin to facilitate front-end, anonymous lead generation forms submitted to Salesforce via cURL to it's Web-to-Lead servlet. The logic and data transfer are working (debug ...
1 vote
3 answers
88 views

Placid plugin - limit returned results

I'm trying to limit the results to 5, but its returning all of the results instead. I am using the below code: {% set options = { cache : false, query : { limit : 5 } } %} {% set timeline =...
  • 671
1 vote
1 answer
788 views

Element API: Remove additional set of square brackets from JSON-String

We're currently having an Android-App access some of the entries of our Craft-based website. We are currently still using a self built API, and for easier creation of new API-Calls we are trying to ...
1 vote
1 answer
306 views

Saving Form Data to Plugin Record via Javascript

I am new to Craft plugin development, so I apologize ahead of time for my lack of understanding. I'm working on a plugin that allows the user to "upload" Excel/csv files via the control panel that ...
2 votes
1 answer
963 views

Element API + JSON data in template

Is there any way to include the JSON response from element API in a template. Let's take the following example: /case-studies.json returns: { data: [ { title: "American ...
2 votes
1 answer
609 views

Feed Me: How to format JSON for a table field?

I need to import some data into a table field. What's the best way to format the data in my original JSON feed? I've tried this: [ "first value", "second value", ] and this: [ {"col1":...
  • 23.6k
2 votes
1 answer
543 views

Feed Me: Importing a relationship between elements

I want to import a bunch of films, which all have certain genres. The genres have already been set up as Categories in Craft, so each genre already has an Element ID (if that's relevant). Here's a ...
  • 23.6k
1 vote
0 answers
195 views

CSV/JSON data imported to dynamic table

I'm looking for a solution that will allow me to turn a CSV or JSON data file into a table on the front-end of a website. Ideally the data would be imported into the database and then output into a ...
6 votes
2 answers
3k views

HTML Purifier Config File

I noticed the following new feature in Craft CMS 2.6.2973: Added the “HTML Purifier Config” setting to Rich Text fields. I can't see any mention or any example of config files in the Craft CMS docs ...
  • 665
3 votes
2 answers
539 views

How to skip the first X entries using ElementAPI

I'm looking how to use the .offset(x) parameters of craft.entries inside the ElementAPI. I tried to add 'offset' => 1 before, after and inside the criteria array, but the x first entries are still ...
3 votes
2 answers
5k views

Passing JSON to Twig

I'm creating a multilingual site and I'm looking to pass some additional configuration data to Twig so I can use it in my template. For example, suppose I have a configuration like this: { "...
1 vote
1 answer
613 views

Redactor can't add image into toolbar

In my rich text field I want to add images to the toolbar. I have done everything that has to be done: I've added "image" to the Standar.json file and selected the Standard.json to be used for the ...
  • 485
2 votes
1 answer
1k views

Image transforms not working properly

I have 2 basic JSON files, the only difference between the files is the product.type('') In my general.php I have turned on 'generateTransformsBeforePageLoad' => true, The first JSON file (200 ...
  • 485
2 votes
1 answer
8k views

Loop through JSON object in Twig from the database

I've written a custom plugin that stores data as JSON in a TEXT column (field_gridcontrol) in Craft's content table that looks something like this: [ { "id": "35", // id is an element's id "...
2 votes
0 answers
781 views

Ordering Element API by Category and Title

I'm looking for a way to order the ElementAPI json array by category and title. I can only get one to work whether it's 'group' => 'stockistRegion.first().title' or 'order' => 'title' using the ...