Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ETL function v2 #27

Open
13 tasks
Tracked by #5
dufoli opened this issue Mar 21, 2024 · 1 comment
Open
13 tasks
Tracked by #5

ETL function v2 #27

dufoli opened this issue Mar 21, 2024 · 1 comment
Assignees
Labels
enhancement New feature or request
Milestone

Comments

@dufoli
Copy link
Owner

dufoli commented Mar 21, 2024

data export: select data then: workflow

  • send data Org to another org (sandbox from prod)
    • login on launch to get sessionid and build sessionid store
  • update selected records Field
    • fixed value
    • object type
    • column id
    • get a value from another column
  • export csv
  • query box
    • can be input with param from context (full list or range of list with batchsize)
  • chain queries (Export using chained queries sorenkrabbe/Chrome-Salesforce-inspector#54) => query can produce a list
    • extract list from query
  • filter

just think to avoid flow function from standard not needed

sorenkrabbe/Chrome-Salesforce-inspector#14

@dufoli dufoli added the enhancement New feature or request label Mar 21, 2024
@dufoli dufoli self-assigned this Mar 21, 2024
@dufoli dufoli changed the title Etl function ETL function Mar 21, 2024
@dufoli dufoli mentioned this issue Mar 21, 2024
96 tasks
@dufoli dufoli added this to the 1.27 milestone Apr 28, 2024
@dufoli dufoli modified the milestones: 1.28, 1.29 Jul 12, 2024
@dufoli
Copy link
Owner Author

dufoli commented Jul 26, 2024

another button on export to add parametter

  • button to add range param
  • layout to paste array of string in csv format or excel format
  • then insert in SOQL :1 or $1 or :2 or $2
  • the execute will detect input and batch soql query to load to datatable

so it mean that we can chain to get metadata or field def for all entity.

The ETL will be in v2

@dufoli dufoli moved this to Todo in Roadmap next release Jul 26, 2024
@dufoli dufoli modified the milestones: 1.29, 1.30, 1.31 Sep 27, 2024
@dufoli dufoli changed the title ETL function ETL function v2 Oct 2, 2024
@dufoli dufoli modified the milestones: 1.30, 1.31 Oct 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
Development

No branches or pull requests

1 participant