Create
Query
database.sqlite
—
execution_data
annotation_tag_entity
auth_identity
auth_provider_sync_history
chat_hub_agents
chat_hub_messages
chat_hub_sessions
credentials_entity
data_table
data_table_column
event_destinations
execution_annotation_tags
execution_annotations
execution_data
execution_entity
execution_metadata
folder
folder_tag
insights_by_period
insights_metadata
insights_raw
installed_nodes
installed_packages
invalid_auth_token
migrations
oauth_access_tokens
oauth_authorization_codes
oauth_clients
oauth_refresh_tokens
oauth_user_consents
processed_data
project
project_relation
role
role_scope
scope
settings
shared_credentials
shared_workflow
sqlite_sequence
tag_entity
test_case_execution
test_run
user
user_api_keys
variables
webhook_entity
workflow_dependency
workflow_entity
workflow_history
workflow_statistics
workflows_tags
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 108 in execution_data
executionId
Primary key.
INT NOT NULL
workflowData
{"id":"mxxAEjU7oSwhgMr4","name":"My workflow","active":false,"nodes":[{"parameters":{"preBuiltAgentsCalloutHttpRequest":"","curlImport":"","method":"POST","url":"https://rapidapi.com","authentication":"none","provideSslCertificates":false,"sendQuery":false,"sendHeaders":true,"specifyHeaders":"keypair","headerParameters":{"parameters":[{"name":"X-RapidAPI-Host","value":"home-depot-product-lookup.p.rapidapi.com"},{"name":"Content-Type","value":"application/json"},{"name":"X-RapidAPI-Key","value":"dc94ea3acbmshb75d467367b8913p190ceejsn2a639985e561"}]},"sendBody":true,"contentType":"json","specifyBody":"keypair","bodyParameters":{"parameters":[{"name":"action","value":"product-lookup"},{"name":"productId","value":"={{ $json['Product Id'] }}"},{"name":"zip","value":"={{ $json['Zip code'] }}"}]},"options":{},"infoMessage":""},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[416,0],"id":"ab7362b3-bb73-4d9b-90eb-ae573339f8b6","name":"HTTP Request"},{"parameters":{"authentication":"none","formTitle":"Product","formDescription":"","formFields":{"values":[{"fieldLabel":"Product Id","fieldType":"text","placeholder":"","requiredField":true},{"fieldLabel":"Zip code","fieldType":"text","placeholder":"","requiredField":true}]},"responseMode":"onReceived","addFormPage":"","options":{}},"type":"n8n-nodes-base.formTrigger","typeVersion":2.3,"position":[0,0],"id":"cf652ef7-054a-4d78-954b-8dcfec50ea17","name":"On form submission","webhookId":"e78e0570-65a9-4f78-9e01-004f760b3cc3"},{"parameters":{"mode":"raw","duplicateItem":false,"jsonOutput":"{\n \"type\": \"object\",\n \"properties\": {\n \"zip\": {\n \"type\": \"string\"\n },\n \"stores\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"object\",\n \"properties\": {\n \"id\": {\n \"type\": \"string\"\n },\n \"vendorId\": {\n \"type\": \"string\"\n },\n \"name\": {\n \"type\": \"string\"\n },\n \"address\": {\n \"type\": \"string\"\n },\n \"city\": {\n \"type\": \"string\"\n },\n \"state\": {\n \"type\": \"string\"\n },\n \"zip\": {\n \"type\": \"string\"\n },\n \"phone\": {\n \"type\": \"string\"\n },\n \"hours\": {\n \"type\": \"object\",\n \"properties\": {\n \"mon\": {\n \"type\": \"object\",\n \"properties\": {\n \"open\": {\n \"type\": \"string\"\n },\n \"close\": {\n \"type\": \"string\"\n }\n }\n },\n \"tue\": {\n \"type\": \"object\",\n \"properties\": {\n \"open\": {\n \"type\": \"string\"\n },\n \"close\": {\n \"type\": \"string\"\n }\n }\n },\n \"wed\": {\n \"type\": \"object\",\n \"properties\": {\n \"open\": {\n \"type\": \"string\"\n },\n \"close\": {\n \"type\": \"string\"\n }\n }\n },\n \"thu\": {\n \"type\": \"object\",\n \"properties\": {\n \"open\": {\n \"type\": \"string\"\n },\n \"close\": {\n \"type\": \"string\"\n }\n }\n },\n \"fri\": {\n \"type\": \"object\",\n \"properties\": {\n \"open\": {\n \"type\": \"string\"\n },\n \"close\": {\n \"type\": \"string\"\n }\n }\n },\n \"sat\": {\n \"type\": \"object\",\n \"properties\": {\n \"open\": {\n \"type\": \"string\"\n },\n \"close\": {\n \"type\": \"string\"\n }\n }\n },\n \"sun\": {\n \"type\": \"object\",\n \"properties\": {\n \"open\": {\n \"type\": \"string\"\n },\n \"close\": {\n \"type\": \"string\"\n }\n }\n }\n }\n },\n \"distance\": {\n \"type\": \"number\"\n },\n \"product\": {\n \"type\": \"object\",\n \"properties\": {\n \"productId\": {\n \"type\": \"string\"\n },\n \"url\": {\n \"type\": \"string\"\n },\n \"name\": {\n \"type\": \"string\"\n },\n \"quantityAvailable\": {\n \"type\": \"integer\"\n },\n \"priceCentsPerUnit\": {\n \"type\": \"integer\"\n },\n \"salePriceCentsPerUnit\": {\n \"type\": \"null\"\n },\n \"bulkPriceCentsPerUnit\": {\n \"type\": \"integer\"\n },\n \"bulkQuantityRequired\": {\n \"type\": \"integer\"\n }\n }\n }\n }\n }\n }\n }\n}","includeOtherFields":false,"options":{}},"type":"n8n-nodes-base.set","typeVersion":3.4,"position":[272,0],"id":"fdcbb001-7fff-4778-8324-bdd6c3b077e8","name":"Edit Fields"}],"connections":{"On form submission":{"main":[[{"node":"Edit Fields","type":"main","index":0}]]},"Edit Fields":{"main":[[{"node":"HTTP Request","type":"main","index":0}]]}},"settings":{"executionOrder":"v1"},"pinData":{"On form submission":[{"json":{"Product Id":"322138483","Zip code":"95816","submittedAt":"2025-12-04T22:24:51.223-08:00","formMode":"test"}}]}}
TEXT NOT NULL
data
[{"startData":"1","resultData":"2","executionData":"3"},{"destinationNode":"4","runNodeFilter":"5"},{"runData":"6","pinData":"7","lastNodeExecuted":"4"},{"contextData":"8","nodeExecutionStack":"9","metadata":"10","waitingExecution":"11","waitingExecutionSource":"12","runtimeData":"13"},"Edit Fields",["14","4"],{"On form submission":"15","Edit Fields":"16"},{"On form submission":"17"},{},[],{},{},{},{"version":1,"establishedAt":1764916085005,"source":"18"},"On form submission",["19"],["20"],["21"],"manual",{"startTime":1764915891275,"executionIndex":0,"source":"22","hints":"23","executionTime":1,"executionStatus":"24","data":"25"},{"startTime":1764916085010,"executionIndex":1,"source":"26","hints":"27","executionTime":9,"executionStatus":"24","data":"28"},{"json":"29"},[],[],"success",{"main":"30"},["31"],[],{"main":"32"},{"Product Id":"33","Zip code":"34","submittedAt":"35","formMode":"36"},["37"],{"previousNode":"14","previousNodeOutput":0,"previousNodeRun":0},["38"],"322138483","95816","2025-12-04T22:24:51.223-08:00","test",["39"],["40"],{"json":"41","pairedItem":"42"},{"json":"43","pairedItem":"44"},{"Product Id":"33","Zip code":"34","submittedAt":"35","formMode":"36"},{"item":0},{"type":"45","properties":"46"},{"item":0},"object",{"zip":"47","stores":"48"},{"type":"49"},{"type":"50","items":"51"},"string","array",{"type":"45","properties":"52"},{"id":"53","vendorId":"54","name":"55","address":"56","city":"57","state":"58","zip":"59","phone":"60","hours":"61","distance":"62","product":"63"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"45","properties":"64"},{"type":"65"},{"type":"45","properties":"66"},{"mon":"67","tue":"68","wed":"69","thu":"70","fri":"71","sat":"72","sun":"73"},"number",{"productId":"74","url":"75","name":"76","quantityAvailable":"77","priceCentsPerUnit":"78","salePriceCentsPerUnit":"79","bulkPriceCentsPerUnit":"80","bulkQuantityRequired":"81"},{"type":"45","properties":"82"},{"type":"45","properties":"83"},{"type":"45","properties":"84"},{"type":"45","properties":"85"},{"type":"45","properties":"86"},{"type":"45","properties":"87"},{"type":"45","properties":"88"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"89"},{"type":"89"},{"type":"90"},{"type":"89"},{"type":"89"},{"open":"91","close":"92"},{"open":"93","close":"94"},{"open":"95","close":"96"},{"open":"97","close":"98"},{"open":"99","close":"100"},{"open":"101","close":"102"},{"open":"103","close":"104"},"integer","null",{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"},{"type":"49"}]
TEXT NOT NULL
Update
Cancel