How to load programmatically webform submissions in Drupal 8

On March 10, 2021 . By CodimTh

Category:

Code snippet that can be used to load programmatically webform submissions in Drupal 8.

$webform = \Drupal\webform\Entity\Webform::load('WEBFORM_ID');  
if ($webform->hasSubmissions()) {
  $query = \Drupal::entityQuery('webform_submission')
    ->condition('webform_id', 'WEBFORM_ID');
  $result = $query->execute();
  $submission_data = [];
  foreach ($result as $item) {
    $submission = \Drupal\webform\Entity\WebformSubmission::load($item);
    $submission_data = $submission->getData();
  }
}

if Entity query of webform submissions returns no results try to add accessCheck(FALSE) to the query like this

$query->accessCheck(FALSE)->execute();

Tags :

Drupal 8 webform Snippets

Comments

Submitted by Antonio (not verified) on Mon, 09/28/2020 - 12:31 Permalink

I tried this code in a custom module and it returned an empty array (the same code in the .theme file did return data).

Submitted by codimth on Wed, 09/30/2020 - 17:25 Permalink

just add ->accessCheck(FALSE); to your query like this example:

$query = \Drupal::entityQuery('webform_submission')
  ->condition('webform_id', $WEBFORM_ID)
  ->accessCheck(FALSE);

$result = $query->execute();

Submitted by Akhil (not verified) on Thu, 03/04/2021 - 19:24 Permalink

How can I add a date created filter to this query? I am attempting to query all the submissions from yesterday. However, the below query is returning all the submissions for me. $dte = date('Y-m-d', strtotime("-1 days")); $query = \Drupal::entityQuery('webform_submission') ->condition('webform_id', 'account_settings') ->condition('created', $dte, '>=');

Submitted by codimth on Tue, 03/09/2021 - 19:54 Permalink

@Akhil here is an example how to add conditions with created field:

$lastDayTimestamp = strtotime('-1 day');

    $query = \Drupal::entityQuery('webform_submission')
        ->condition('webform_id', 'contact')
        ->condition('created', $lastDayTimestamp, '>=')
        ->accessCheck(FALSE);

    $result = $query->execute();
    foreach ($result as $item) {
        $submission = \Drupal\webform\Entity\WebformSubmission::load($item);
        $submission->delete();
    }