Récupère l'heure à laquelle la dernière exécution des données s'est terminée, quel que soit l'état de l'exécution.
Renvois
Date : heure de la dernière exécution, ou null s'il n'y a jamais eu d'exécution de données.
getLastRefreshedTime()
Récupère l'heure à laquelle les données ont été actualisées pour la dernière fois.
Renvois
Date : dernière date et heure d'actualisation réussie, ou null si l'exécution des données n'a jamais abouti.
isTruncated()
Renvoie true si les données de la dernière exécution réussie sont tronquées, ou false dans le cas contraire.
Renvois
Boolean : True si les données d'exécution sont tronquées, ou false dans le cas contraire.
Sauf indication contraire, le contenu de cette page est régi par une licence Creative Commons Attribution 4.0, et les échantillons de code sont régis par une licence Apache 2.0. Pour en savoir plus, consultez les Règles du site Google Developers. Java est une marque déposée d'Oracle et/ou de ses sociétés affiliées.
Dernière mise à jour le 2025/07/26 (UTC).
[[["Facile à comprendre","easyToUnderstand","thumb-up"],["J'ai pu résoudre mon problème","solvedMyProblem","thumb-up"],["Autre","otherUp","thumb-up"]],[["Il n'y a pas l'information dont j'ai besoin","missingTheInformationINeed","thumb-down"],["Trop compliqué/Trop d'étapes","tooComplicatedTooManySteps","thumb-down"],["Obsolète","outOfDate","thumb-down"],["Problème de traduction","translationIssue","thumb-down"],["Mauvais exemple/Erreur de code","samplesCodeIssue","thumb-down"],["Autre","otherDown","thumb-down"]],["Dernière mise à jour le 2025/07/26 (UTC)."],[[["\u003cp\u003e\u003ccode\u003eDataExecutionStatus\u003c/code\u003e provides methods to access the state and details of a data execution, including error information and timing.\u003c/p\u003e\n"],["\u003cp\u003eYou can retrieve the execution state, error code, and error message using dedicated methods.\u003c/p\u003e\n"],["\u003cp\u003eTimestamps for the last execution and successful refresh are accessible for tracking data updates.\u003c/p\u003e\n"],["\u003cp\u003eA method is available to determine if the data from the last successful execution was truncated.\u003c/p\u003e\n"]]],["The `DataExecutionStatus` provides information about data execution. It allows retrieving the error code and message, alongside the execution state. It also details the last execution time and the last successful refresh time. Additionally, it indicates whether the data from the last successful execution was truncated. The class provide methods for accessing those information like `getErrorCode()`, `getErrorMessage()`, `getExecutionState()`, `getLastExecutionTime()`, `getLastRefreshedTime()` and `isTruncated()`.\n"],null,["DataExecutionStatus\n\nThe data execution status. \n\nMethods\n\n| Method | Return type | Brief description |\n|---------------------------------------------------|----------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------|\n| [getErrorCode()](#getErrorCode()) | [DataExecutionErrorCode](/apps-script/reference/spreadsheet/data-execution-error-code) | Gets the error code of the data execution. |\n| [getErrorMessage()](#getErrorMessage()) | `String` | Gets the error message of the data execution. |\n| [getExecutionState()](#getExecutionState()) | [DataExecutionState](/apps-script/reference/spreadsheet/data-execution-state) | Gets the state of the data execution. |\n| [getLastExecutionTime()](#getLastExecutionTime()) | `Date` | Gets the time the last data execution completed regardless of the execution state. |\n| [getLastRefreshedTime()](#getLastRefreshedTime()) | `Date` | Gets the time the data last successfully refreshed. |\n| [isTruncated()](#isTruncated()) | `Boolean` | Returns `true` if the data from last successful execution is truncated, or `false` otherwise. |\n\nDetailed documentation \n\n`get``Error``Code()` \nGets the error code of the data execution.\n\nReturn\n\n\n[DataExecutionErrorCode](/apps-script/reference/spreadsheet/data-execution-error-code) --- The error code.\n\n*** ** * ** ***\n\n`get``Error``Message()` \nGets the error message of the data execution. The message may be empty.\n\nReturn\n\n\n`String` --- The error message.\n\n*** ** * ** ***\n\n`get``Execution``State()` \nGets the state of the data execution.\n\nReturn\n\n\n[DataExecutionState](/apps-script/reference/spreadsheet/data-execution-state) --- The execution state.\n\n*** ** * ** ***\n\n`get``Last``Execution``Time()` \nGets the time the last data execution completed regardless of the execution state.\n\nReturn\n\n\n`Date` --- The last execution time, or `null` if there has never been a data execution.\n\n*** ** * ** ***\n\n`get``Last``Refreshed``Time()` \nGets the time the data last successfully refreshed.\n\nReturn\n\n\n`Date` --- The last successfully refreshed time, or `null` if there is never a successful\ndata execution.\n\n*** ** * ** ***\n\n`is``Truncated()` \nReturns `true` if the data from last successful execution is truncated, or `false`\notherwise.\n\nReturn\n\n\n`Boolean` --- `True` if the data from execution is truncated, or `false` otherwise."]]
