Skip to content

Update records by query

Description

Updates all the selected fields in every record that exist in the record-list

Input Ports

Name dataType sourceType required description
Store Key text link-manual true The Store Key of the store the user wants to update
Shape shape manual-only true The shape the user wants to select fields from
Fields text-list manual-only The fields the user wants to update
Record-list record-list link-only true The new values the user wants to update to

Scenarios

  • The user wants to update every record based on the fields selected

Use case

Update Record in Store Record-list Command

Inputs
  • Store Key: Temporary Store
  • Shape: Account Shape
  • Fields: accountNumber, balance
  • Record-list: json { type: 'record-list', shape: { _id: '4be5caf2-9e32-41cf-947e-1f5ed99ec074', slug: '@SuperBro_Excel-data-Shape', name: 'Excel data Shape', packageVersion: '0.1.0', tree: [ [Object], [Object] ], settings: { title: 'Excel Shape', description: '' } }, data: [ { _id: '049633c4-8ecd-4a9a-9b17-5eb4cb2ca262', createdAt: 2021-11-09T11:45:34.000Z, updatedAt: 2021-11-09T11:45:34.000Z, accountNumber: '62657479773', filepath: 'C:\\Roboteur\\BankStatements\\csv\\62600079773.csv' }, { _id: '4b0463a4-432b-4f05-9ad6-048e8594a684', createdAt: 2021-11-09T11:45:40.000Z, updatedAt: 2021-11-09T11:45:40.000Z, accountNumber: '62854058700', filepath: 'C:\\Roboteur\\BankStatements\\csv\\62600079773.csv' }, { _id: 'cb95deb9-b9c0-4469-9a78-59ab83220859', createdAt: 2021-11-09T11:45:26.000Z, updatedAt: 2021-11-09T11:45:26.000Z, accountNumber: '62841795323-11', filepath: 'C:\\Roboteur\\BankStatements\\csv\\62600079773.csv' } ] }
Search Tags

Update entire record-list based on fields