You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by zh...@apache.org on 2022/07/14 15:46:28 UTC
[incubator-devlake] branch main updated: Issues/2408 collect orgs for user in github (#2494)
This is an automated email from the ASF dual-hosted git repository.
zhangliang2022 pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/main by this push:
new 646b1a9f Issues/2408 collect orgs for user in github (#2494)
646b1a9f is described below
commit 646b1a9f2292db9befb0d42dae44ca96aef8348d
Author: likyh <l...@likyh.com>
AuthorDate: Thu Jul 14 23:46:23 2022 +0800
Issues/2408 collect orgs for user in github (#2494)
* feat: collect account orgs
* ci: add e2e test
* ci: fix for e2e
* fix: desensitization for jira user
Co-authored-by: linyh <ya...@meri.co>
---
plugins/github/e2e/account_test.go | 10 +++
.../raw_tables/_raw_github_api_account_orgs.csv | 14 ++++
.../snapshot_tables/_tool_github_account_orgs.csv | 30 +++++++
plugins/github/e2e/snapshot_tables/account.csv | 6 +-
plugins/github/impl/impl.go | 2 +
.../register.go => account_org.go} | 20 +++--
plugins/github/models/migrationscripts/register.go | 1 +
.../updateSchemas20220713000004.go | 50 +++++++++++
plugins/github/tasks/account_convertor.go | 31 ++++++-
plugins/github/tasks/account_org_collector.go | 98 ++++++++++++++++++++++
plugins/github/tasks/account_org_extractor.go | 80 ++++++++++++++++++
.../jira/e2e/raw_tables/_raw_jira_api_users.csv | 56 ++++++-------
.../e2e/snapshot_tables/_tool_jira_accounts.csv | 56 ++++++-------
plugins/jira/e2e/snapshot_tables/accounts.csv | 60 ++++++-------
14 files changed, 416 insertions(+), 98 deletions(-)
diff --git a/plugins/github/e2e/account_test.go b/plugins/github/e2e/account_test.go
index a9793b0b..21232aa7 100644
--- a/plugins/github/e2e/account_test.go
+++ b/plugins/github/e2e/account_test.go
@@ -55,6 +55,16 @@ func TestAccountDataFlow(t *testing.T) {
IgnoreTypes: []interface{}{common.NoPKModel{}},
})
+ // import raw data table
+ dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_github_api_account_orgs.csv", "_raw_github_api_account_orgs")
+ // verify extraction
+ dataflowTester.FlushTabler(&models.GithubAccountOrg{})
+ dataflowTester.Subtask(tasks.ExtractAccountOrgMeta, taskData)
+ dataflowTester.VerifyTableWithOptions(&models.GithubAccountOrg{}, e2ehelper.TableOptions{
+ CSVRelPath: "./snapshot_tables/_tool_github_account_orgs.csv",
+ IgnoreTypes: []interface{}{common.NoPKModel{}},
+ })
+
// verify converter
dataflowTester.FlushTabler(&crossdomain.Account{})
dataflowTester.Subtask(tasks.ConvertAccountsMeta, taskData)
diff --git a/plugins/github/e2e/raw_tables/_raw_github_api_account_orgs.csv b/plugins/github/e2e/raw_tables/_raw_github_api_account_orgs.csv
new file mode 100644
index 00000000..4a6c36ca
--- /dev/null
+++ b/plugins/github/e2e/raw_tables/_raw_github_api_account_orgs.csv
@@ -0,0 +1,14 @@
+id,params,data,url,input,created_at
+1,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}",[],https://api.github.com/users/rikewang/orgs,"{""Login"": ""rikewang"", ""AccountId"": 24841832}",2022-07-13T13:44:47.694+00:00
+2,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}",[],https://api.github.com/users/aetherwu/orgs,"{""Login"": ""aetherwu"", ""AccountId"": 1645472}",2022-07-13T13:44:47.761+00:00
+3,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}","[{""login"":""exotel"",""id"":1755975,""node_id"":""MDEyOk9yZ2FuaXphdGlvbjE3NTU5NzU="",""url"":""https://api.github.com/orgs/exotel"",""repos_url"":""https://api.github.com/orgs/exotel/repos"",""events_url"":""https://api.github.com/orgs/exotel/events"",""hooks_url"":""https://api.github.com/orgs/exotel/hooks"",""issues_url"":""https://api.github.com/orgs/exotel/issues"",""members_url"":""https://api.github.com/orgs/exot [...]
+4,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}",[],https://api.github.com/users/king526/orgs,"{""Login"": ""king526"", ""AccountId"": 38849208}",2022-07-13T13:44:48.132+00:00
+5,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}",[],https://api.github.com/users/shanghai-Jerry/orgs,"{""Login"": ""shanghai-Jerry"", ""AccountId"": 12420699}",2022-07-13T13:44:48.481+00:00
+6,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}",[],https://api.github.com/users/gitter-badger/orgs,"{""Login"": ""gitter-badger"", ""AccountId"": 8518239}",2022-07-13T13:44:48.675+00:00
+7,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}",[],https://api.github.com/users/zhangyuanxue/orgs,"{""Login"": ""zhangyuanxue"", ""AccountId"": 32893410}",2022-07-13T13:44:48.863+00:00
+8,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}","[{""login"":""COSCUP"",""id"":720461,""node_id"":""MDEyOk9yZ2FuaXphdGlvbjcyMDQ2MQ=="",""url"":""https://api.github.com/orgs/COSCUP"",""repos_url"":""https://api.github.com/orgs/COSCUP/repos"",""events_url"":""https://api.github.com/orgs/COSCUP/events"",""hooks_url"":""https://api.github.com/orgs/COSCUP/hooks"",""issues_url"":""https://api.github.com/orgs/COSCUP/issues"",""members_url"":""https://api.github.com/orgs/COSCU [...]
+9,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}","[{""login"":""ankiband"",""id"":61872787,""node_id"":""MDEyOk9yZ2FuaXphdGlvbjYxODcyNzg3"",""url"":""https://api.github.com/orgs/ankiband"",""repos_url"":""https://api.github.com/orgs/ankiband/repos"",""events_url"":""https://api.github.com/orgs/ankiband/events"",""hooks_url"":""https://api.github.com/orgs/ankiband/hooks"",""issues_url"":""https://api.github.com/orgs/ankiband/issues"",""members_url"":""https://api.github. [...]
+10,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}",[],https://api.github.com/users/chensanle/orgs,"{""Login"": ""chensanle"", ""AccountId"": 31087327}",2022-07-13T13:44:49.622+00:00
+11,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}",[],https://api.github.com/users/runner-mei/orgs,"{""Login"": ""runner-mei"", ""AccountId"": 1052632}",2022-07-13T13:44:49.743+00:00
+12,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}",[],https://api.github.com/users/ppmoon/orgs,"{""Login"": ""ppmoon"", ""AccountId"": 3971390}",2022-07-13T13:44:49.745+00:00
+13,"{""ConnectionId"":1,""Owner"":""panjf2000"",""Repo"":""ants""}",[],https://api.github.com/users/codecov[bot]/orgs,"{""Login"": ""codecov[bot]"", ""AccountId"": 22429695}",2022-07-13T13:44:49.813+00:00
diff --git a/plugins/github/e2e/snapshot_tables/_tool_github_account_orgs.csv b/plugins/github/e2e/snapshot_tables/_tool_github_account_orgs.csv
new file mode 100644
index 00000000..3640ae72
--- /dev/null
+++ b/plugins/github/e2e/snapshot_tables/_tool_github_account_orgs.csv
@@ -0,0 +1,30 @@
+connection_id,account_id,org_id,org_login
+1,21979,720461,COSCUP
+1,21979,1064938,nodejs-tw
+1,21979,1102355,moztw
+1,21979,1136800,h5bp
+1,21979,1198582,CodeIgniter-TW
+1,21979,2181346,drone
+1,21979,2330436,Getmore
+1,21979,2357470,golangtw
+1,21979,6195619,laravel-taiwan
+1,21979,7203045,go-xorm
+1,21979,7894478,gin-gonic
+1,21979,8412157,PHPConf-TW
+1,21979,8500553,Mediatek-Cloud
+1,21979,10098849,SJFinder
+1,21979,12724356,go-gitea
+1,21979,13902473,laradock
+1,21979,15729372,gin-contrib
+1,21979,21114819,tagfans
+1,21979,25333538,maintainers
+1,21979,26264181,go-training
+1,21979,32427691,go-ggz
+1,21979,40886133,the-benchmarker
+1,21979,88956536,golang-queue
+1,964542,1755975,exotel
+1,964542,38272046,leadmrktr
+1,964542,43889607,shellagilehub
+1,964542,48060817,odysseyhack
+1,964542,58340304,boodltech
+1,14950473,61872787,ankiband
diff --git a/plugins/github/e2e/snapshot_tables/account.csv b/plugins/github/e2e/snapshot_tables/account.csv
index aea2654c..adf6a806 100644
--- a/plugins/github/e2e/snapshot_tables/account.csv
+++ b/plugins/github/e2e/snapshot_tables/account.csv
@@ -2,8 +2,8 @@ id,email,full_name,user_name,avatar_url,organization,created_date,status
github:GithubAccount:1:1052632,runner.mei@,runner,runner-mei,https://avatars.githubusercontent.com/u/1052632?v=4,,,0
github:GithubAccount:1:11763614,zhaozh90@163.com,Jerry,Moonlight-Zhao,https://avatars.githubusercontent.com/u/11763614?v=4,,,0
github:GithubAccount:1:12420699,,Jerry You,shanghai-Jerry,https://avatars.githubusercontent.com/u/12420699?v=4,,,0
-github:GithubAccount:1:14950473,,Z.Q.K,zqkgo,https://avatars.githubusercontent.com/u/14950473?v=4,,,0
-github:GithubAccount:1:21979,appleboy.tw@gmail.com,Bo-Yi Wu,appleboy,https://avatars.githubusercontent.com/u/21979?v=4,,,0
+github:GithubAccount:1:14950473,,Z.Q.K,zqkgo,https://avatars.githubusercontent.com/u/14950473?v=4,ankiband,,0
+github:GithubAccount:1:21979,appleboy.tw@gmail.com,Bo-Yi Wu,appleboy,https://avatars.githubusercontent.com/u/21979?v=4,"COSCUP,nodejs-tw,moztw,h5bp,CodeIgniter-TW,drone,Getmore,golangtw,laravel-taiwan,go-xorm,gin-gonic,PHPConf-TW,Mediatek-Cloud,SJFinder,go-gitea,laradock,gin-contrib,tagfans,maintainers,go-training,go-ggz,the-benchmarker,golang-queue",,0
github:GithubAccount:1:22429695,,,codecov[bot],https://avatars.githubusercontent.com/in/254?v=4,,,0
github:GithubAccount:1:24841832,,,rikewang,https://avatars.githubusercontent.com/u/24841832?v=4,,,0
github:GithubAccount:1:31087327,,sanle,chensanle,https://avatars.githubusercontent.com/u/31087327?v=4,,,0
@@ -13,4 +13,4 @@ github:GithubAccount:1:38849208,,,king526,https://avatars.githubusercontent.com/
github:GithubAccount:1:3971390,cnliuyunpeng@gmail.com,ppmoon,ppmoon,https://avatars.githubusercontent.com/u/3971390?v=4,,,0
github:GithubAccount:1:7496278,i@andypan.me,Andy Pan,panjf2000,https://avatars.githubusercontent.com/u/7496278?v=4,,,0
github:GithubAccount:1:8518239,badger@gitter.im,The Gitter Badger,gitter-badger,https://avatars.githubusercontent.com/u/8518239?v=4,,,0
-github:GithubAccount:1:964542,sarath.sp06@gmail.com,Sarath Sadasivan Pillai,sarathsp06,https://avatars.githubusercontent.com/u/964542?v=4,,,0
+github:GithubAccount:1:964542,sarath.sp06@gmail.com,Sarath Sadasivan Pillai,sarathsp06,https://avatars.githubusercontent.com/u/964542?v=4,"exotel,leadmrktr,shellagilehub,odysseyhack,boodltech",,0
diff --git a/plugins/github/impl/impl.go b/plugins/github/impl/impl.go
index adcb3a9e..9eb826c5 100644
--- a/plugins/github/impl/impl.go
+++ b/plugins/github/impl/impl.go
@@ -74,6 +74,8 @@ func (plugin Github) SubTaskMetas() []core.SubTaskMeta {
tasks.ExtractMilestonesMeta,
tasks.CollectAccountMeta,
tasks.ExtractAccountMeta,
+ tasks.CollectAccountOrgMeta,
+ tasks.ExtractAccountOrgMeta,
tasks.EnrichPullRequestIssuesMeta,
tasks.ConvertRepoMeta,
tasks.ConvertIssuesMeta,
diff --git a/plugins/github/models/migrationscripts/register.go b/plugins/github/models/account_org.go
similarity index 64%
copy from plugins/github/models/migrationscripts/register.go
copy to plugins/github/models/account_org.go
index f389997b..4840bba9 100644
--- a/plugins/github/models/migrationscripts/register.go
+++ b/plugins/github/models/account_org.go
@@ -15,16 +15,20 @@ See the License for the specific language governing permissions and
limitations under the License.
*/
-package migrationscripts
+package models
import (
- "github.com/apache/incubator-devlake/migration"
+ "github.com/apache/incubator-devlake/models/common"
)
-// All return all the migration scripts
-func All() []migration.Script {
- return []migration.Script{
- new(initSchemas),
- new(updateSchemas20220713000003),
- }
+type GithubAccountOrg struct {
+ ConnectionId uint64 `gorm:"primaryKey"`
+ AccountId int `gorm:"primaryKey;autoIncrement:false"`
+ OrgId int `gorm:"primaryKey;autoIncrement:false"`
+ OrgLogin string `json:"org_login" gorm:"type:varchar(255)"`
+ common.NoPKModel
+}
+
+func (GithubAccountOrg) TableName() string {
+ return "_tool_github_account_orgs"
}
diff --git a/plugins/github/models/migrationscripts/register.go b/plugins/github/models/migrationscripts/register.go
index f389997b..5afe3dfe 100644
--- a/plugins/github/models/migrationscripts/register.go
+++ b/plugins/github/models/migrationscripts/register.go
@@ -26,5 +26,6 @@ func All() []migration.Script {
return []migration.Script{
new(initSchemas),
new(updateSchemas20220713000003),
+ new(updateSchemas20220713000004),
}
}
diff --git a/plugins/github/models/migrationscripts/updateSchemas20220713000004.go b/plugins/github/models/migrationscripts/updateSchemas20220713000004.go
new file mode 100644
index 00000000..09cc11f3
--- /dev/null
+++ b/plugins/github/models/migrationscripts/updateSchemas20220713000004.go
@@ -0,0 +1,50 @@
+/*
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+*/
+
+package migrationscripts
+
+import (
+ "context"
+ "github.com/apache/incubator-devlake/models/migrationscripts/archived"
+ "gorm.io/gorm"
+)
+
+type GithubAccountOrg20220713 struct {
+ ConnectionId uint64 `gorm:"primaryKey"`
+ AccountId int `gorm:"primaryKey;autoIncrement:false"`
+ OrgId int `gorm:"primaryKey;autoIncrement:false"`
+ OrgLogin string `json:"org_login" gorm:"type:varchar(255)"`
+ archived.NoPKModel
+}
+
+func (GithubAccountOrg20220713) TableName() string {
+ return "_tool_github_account_orgs"
+}
+
+type updateSchemas20220713000004 struct{}
+
+func (*updateSchemas20220713000004) Up(ctx context.Context, db *gorm.DB) error {
+ return db.Migrator().AutoMigrate(&GithubAccountOrg20220713{})
+}
+
+func (*updateSchemas20220713000004) Version() uint64 {
+ return 20220713000004
+}
+
+func (*updateSchemas20220713000004) Name() string {
+ return "UpdateSchemas for add org in 20220713"
+}
diff --git a/plugins/github/tasks/account_convertor.go b/plugins/github/tasks/account_convertor.go
index 9892b67a..70d18c71 100644
--- a/plugins/github/tasks/account_convertor.go
+++ b/plugins/github/tasks/account_convertor.go
@@ -18,7 +18,9 @@ limitations under the License.
package tasks
import (
+ "github.com/apache/incubator-devlake/models/common"
"reflect"
+ "strings"
"github.com/apache/incubator-devlake/models/domainlayer/crossdomain"
@@ -39,6 +41,12 @@ var ConvertAccountsMeta = core.SubTaskMeta{
DomainTypes: core.DOMAIN_TYPES,
}
+type GithubAccountWithOrg struct {
+ githubModels.GithubAccount
+ Login string `json:"login" gorm:"type:varchar(255)"`
+ common.NoPKModel
+}
+
func ConvertAccounts(taskCtx core.SubTaskContext) error {
db := taskCtx.GetDal()
data := taskCtx.GetData().(*GithubTaskData)
@@ -61,16 +69,37 @@ func ConvertAccounts(taskCtx core.SubTaskContext) error {
Owner: data.Options.Owner,
Repo: data.Options.Repo,
},
- Table: RAW_COMMIT_TABLE,
+ Table: RAW_ACCOUNT_TABLE,
},
Convert: func(inputRow interface{}) ([]interface{}, error) {
githubUser := inputRow.(*githubModels.GithubAccount)
+
+ // query related orgs
+ var orgs []string
+ err := db.Pluck(`org_login`, &orgs,
+ dal.From(&githubModels.GithubAccountOrg{}),
+ dal.Where(`account_id = ? and connection_id = ?`, githubUser.Id, data.Options.ConnectionId),
+ )
+ if err != nil {
+ return nil, err
+ }
+ var orgStr string
+ if len(orgs) == 0 {
+ orgStr = ``
+ } else {
+ orgStr = strings.Join(orgs, `,`)
+ if len(orgStr) > 255 {
+ orgStr = orgStr[:255]
+ }
+ }
+
domainUser := &crossdomain.Account{
DomainEntity: domainlayer.DomainEntity{Id: accountIdGen.Generate(data.Options.ConnectionId, githubUser.Id)},
Email: githubUser.Email,
FullName: githubUser.Name,
UserName: githubUser.Login,
AvatarUrl: githubUser.AvatarUrl,
+ Organization: orgStr,
}
return []interface{}{
domainUser,
diff --git a/plugins/github/tasks/account_org_collector.go b/plugins/github/tasks/account_org_collector.go
new file mode 100644
index 00000000..d7296d81
--- /dev/null
+++ b/plugins/github/tasks/account_org_collector.go
@@ -0,0 +1,98 @@
+/*
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+*/
+
+package tasks
+
+import (
+ "encoding/json"
+ "io/ioutil"
+ "net/http"
+ "reflect"
+
+ "github.com/apache/incubator-devlake/plugins/core/dal"
+
+ "github.com/apache/incubator-devlake/plugins/helper"
+
+ "github.com/apache/incubator-devlake/plugins/core"
+ "github.com/apache/incubator-devlake/plugins/github/models"
+)
+
+const RAW_ACCOUNT_ORG_TABLE = "github_api_account_orgs"
+
+type SimpleAccountWithId struct {
+ Login string
+ AccountId int
+}
+
+func CollectAccountOrg(taskCtx core.SubTaskContext) error {
+ db := taskCtx.GetDal()
+ data := taskCtx.GetData().(*GithubTaskData)
+
+ cursor, err := db.Cursor(
+ dal.Select("_tool_github_repo_accounts.login,_tool_github_repo_accounts.account_id"),
+ dal.From(models.GithubRepoAccount{}.TableName()),
+ dal.Join(`left join _tool_github_accounts ga on (
+ ga.connection_id = _tool_github_repo_accounts.connection_id
+ AND ga.id = _tool_github_repo_accounts.account_id
+ AND ga.type = 'User'
+ )`),
+ dal.Where("_tool_github_repo_accounts.repo_github_id = ? and _tool_github_repo_accounts.connection_id=?",
+ data.Repo.GithubId, data.Options.ConnectionId),
+ )
+ if err != nil {
+ return err
+ }
+ iterator, err := helper.NewDalCursorIterator(db, cursor, reflect.TypeOf(SimpleAccountWithId{}))
+ if err != nil {
+ return err
+ }
+ collector, err := helper.NewApiCollector(helper.ApiCollectorArgs{
+ RawDataSubTaskArgs: helper.RawDataSubTaskArgs{
+ Ctx: taskCtx,
+ Params: GithubApiParams{
+ ConnectionId: data.Options.ConnectionId,
+ Owner: data.Options.Owner,
+ Repo: data.Options.Repo,
+ },
+ Table: RAW_ACCOUNT_ORG_TABLE,
+ },
+ ApiClient: data.ApiClient,
+ Input: iterator,
+ UrlTemplate: "/users/{{ .Input.Login }}/orgs",
+ ResponseParser: func(res *http.Response) ([]json.RawMessage, error) {
+ body, err := ioutil.ReadAll(res.Body)
+ if err != nil {
+ return nil, err
+ }
+ res.Body.Close()
+ return []json.RawMessage{body}, nil
+ },
+ })
+
+ if err != nil {
+ return err
+ }
+ return collector.Execute()
+}
+
+var CollectAccountOrgMeta = core.SubTaskMeta{
+ Name: "collectAccountOrg",
+ EntryPoint: CollectAccountOrg,
+ EnabledByDefault: true,
+ Description: "Collect accounts org data from Github api",
+ DomainTypes: []string{core.DOMAIN_TYPE_CROSS},
+}
diff --git a/plugins/github/tasks/account_org_extractor.go b/plugins/github/tasks/account_org_extractor.go
new file mode 100644
index 00000000..dc43c373
--- /dev/null
+++ b/plugins/github/tasks/account_org_extractor.go
@@ -0,0 +1,80 @@
+/*
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+*/
+
+package tasks
+
+import (
+ "encoding/json"
+ "github.com/apache/incubator-devlake/plugins/core"
+ "github.com/apache/incubator-devlake/plugins/github/models"
+ "github.com/apache/incubator-devlake/plugins/helper"
+)
+
+var ExtractAccountOrgMeta = core.SubTaskMeta{
+ Name: "ExtractAccountOrg",
+ EntryPoint: ExtractAccountOrg,
+ EnabledByDefault: true,
+ Description: "Extract raw account org data into tool layer table github_account_orgs",
+ DomainTypes: []string{core.DOMAIN_TYPE_CROSS},
+}
+
+type GithubAccountOrgsResponse struct {
+ Login string `json:"login"`
+ Id int `json:"id"`
+ NodeId string `json:"node_id"`
+ AvatarUrl string `json:"avatar_url"`
+ Description string `json:"description"`
+}
+
+func ExtractAccountOrg(taskCtx core.SubTaskContext) error {
+ data := taskCtx.GetData().(*GithubTaskData)
+ extractor, err := helper.NewApiExtractor(helper.ApiExtractorArgs{
+ RawDataSubTaskArgs: helper.RawDataSubTaskArgs{
+ Ctx: taskCtx,
+ Params: GithubApiParams{
+ ConnectionId: data.Options.ConnectionId,
+ Owner: data.Options.Owner,
+ Repo: data.Options.Repo,
+ },
+ Table: RAW_ACCOUNT_ORG_TABLE,
+ },
+ Extract: func(row *helper.RawData) ([]interface{}, error) {
+ apiAccountOrgs := &[]GithubAccountOrgsResponse{}
+ err := json.Unmarshal(row.Data, apiAccountOrgs)
+ simpleAccount := &SimpleAccountWithId{}
+ err = json.Unmarshal(row.Input, simpleAccount)
+ if err != nil {
+ return nil, err
+ }
+ results := make([]interface{}, 0, len(*apiAccountOrgs))
+ for _, apiAccountOrg := range *apiAccountOrgs {
+ githubAccount := &models.GithubAccountOrg{
+ ConnectionId: data.Options.ConnectionId,
+ AccountId: simpleAccount.AccountId,
+ OrgId: apiAccountOrg.Id,
+ OrgLogin: apiAccountOrg.Login,
+ }
+ results = append(results, githubAccount)
+ }
+ return results, nil
+ },
+ })
+ if err != nil {
+ return err
+ }
+ return extractor.Execute()
+}
diff --git a/plugins/jira/e2e/raw_tables/_raw_jira_api_users.csv b/plugins/jira/e2e/raw_tables/_raw_jira_api_users.csv
index cce81945..902e1a6e 100644
--- a/plugins/jira/e2e/raw_tables/_raw_jira_api_users.csv
+++ b/plugins/jira/e2e/raw_tables/_raw_jira_api_users.csv
@@ -1,31 +1,31 @@
"id","params","data","url","input","created_at"
812101,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=557058:f58131cb-b67d-43c7-b30d-6b58d40bd077"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""557058:f58131cb-b67d-43c7-b30d-6b58d40bd077"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/600529a9c8bfef89daa848e6db28ed2d?d=https%3A%2F [...]
812102,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=557058:46121f43-e58d-4ff4-83fd-a79fb4b71b45"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""557058:46121f43-e58d-4ff4-83fd-a79fb4b71b45"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/97f7c79b50890409584990ddde1920b3?d=https%3A%2F [...]
-812103,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5e9711ba34f7b90c0fbc37d3"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5e9711ba34f7b90c0fbc37d3"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/f1e7dd8eadd9170aff5df20da45c849d?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812104,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0947d31e0c2a15fd83"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0947d31e0c2a15fd83"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/fa7eb84a8ad9e90ff75a00dcc134ba4c?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
-812105,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0984083c0c12e5af8f"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0984083c0c12e5af8f"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0984083c0c12e5af8f/8bd19c25-c051-47f3-a41a- [...]
-812106,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0a47d31e0c2a15fd87"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0a47d31e0c2a15fd87"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/70034f92b12867f30613f25aadf6f8ca?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
-812107,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0aaa47a00c1997ea8e"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0aaa47a00c1997ea8e"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/dfc23cdb7938ba887badda2e3fac179d?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
-812108,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0b0827650c1eeb2ab6"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0b0827650c1eeb2ab6"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0b0827650c1eeb2ab6/8f882204-a169-4200-8a07 [...]
-812109,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0ba04d9c0c220c18d8"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 3, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0ba04d9c0c220c18d8"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0ba04d9c0c220c18d8/22fb069e-32f9-4ab8-be11- [...]
-812110,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0beb77320c1f821a26"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 4, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0beb77320c1f821a26"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0beb77320c1f821a26/bb1e828a-f91b-4237-85b0- [...]
-812111,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0c2490cf0c09e2e598"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0c2490cf0c09e2e598"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/21c497af87015df6beee68b1829ccd38?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812112,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0c730ec90c1999cadf"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0c730ec90c1999cadf"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/9f2459a1fcb78fd5c1d8b70bf3917992?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812113,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5eec896fe571480ac2ae6ede"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 5, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5eec896fe571480ac2ae6ede"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5eec896fe571480ac2ae6ede/1a02d070-08b5-43df-bd7f- [...]
-812114,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5eef5ae43589f00ab40dc60f"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5eef5ae43589f00ab40dc60f"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/133f8093dfaf54f4a11902ad59702877?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812115,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5eef5ae43589f00ab40dc611"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5eef5ae43589f00ab40dc611"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/1f32b08d4afe93746e310bd3de23ff01?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812116,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ef16f3e7e95e80a81fedc0a"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ef16f3e7e95e80a81fedc0a"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/14370ded2a7ce4669403f7f895961c58?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
-812117,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ef3254a8624070abc590972"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ef3254a8624070abc590972"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/24c4783eaa37f4e32874cd58dae0a4b2?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812118,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f032527e407a4001cf04d5c"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f032527e407a4001cf04d5c"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/7967062a702c1bb9fa629748ab219f37?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
-812119,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f05f5b15ee2c300233b4436"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f05f5b15ee2c300233b4436"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/69667c2c63ce892e11b9ac098e3abc4f?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812120,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f184c6dd680320021c3f8a1"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f184c6dd680320021c3f8a1"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/849b584b0be6e2ab58555276fdb4e565?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812121,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f32012eea5e2f0039284885"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f32012eea5e2f0039284885"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/64fa1e6f684df098f2c748096893fbcc?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
-812122,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f32012f347294003ed909fb"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f32012f347294003ed909fb"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/d1d69b6c79d3ef5f1c92022969a15485?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812123,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f586b28df83ab007d759bfa"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f586b28df83ab007d759bfa"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/401fe3b2e223239efc2e6407ebfcf77d?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812124,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f5ede6f3242e8006f3bd173"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f5ede6f3242e8006f3bd173"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f5ede6f3242e8006f3bd173/fdfa3399-fe03-40d7-8c11- [...]
-812125,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f6c41784147d6007749dd66"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 4, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f6c41784147d6007749dd66"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f6c41784147d6007749dd66/036cd333-40df-4b47-a5ee- [...]
-812126,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f73f85158899e007055c7d3"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f73f85158899e007055c7d3"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/dc81db75677218a2dce93b7abee1a752?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812127,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f8d380729bd8a006f5a90a0"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f8d380729bd8a006f5a90a0"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/bf2a5e92812cfcc9c1ac29582d619a19?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812128,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5fa8b6d142ab3b006eaa6f42"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5fa8b6d142ab3b006eaa6f42"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fa8b6d142ab3b006eaa6f42/a000c4fd-4022-4110-8a89- [...]
-812129,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5fab870b7cfc240071f37525"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5fab870b7cfc240071f37525"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/8d37abf9dd0fef7ab3f9123d641d791e?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
-812130,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5fb48fe20d2f61006f0d0106"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5fb48fe20d2f61006f0d0106"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fb48fe20d2f61006f0d0106/3233dbe8-0b15-45fa-96f3 [...]
+812103,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5e9711ba34f7b90c0fbc37d3"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5e9711ba34f7b90c0fbc37d3"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/f1e7dd8eadd9170aff5df20da45c849d?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812104,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0947d31e0c2a15fd83"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0947d31e0c2a15fd83"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/fa7eb84a8ad9e90ff75a00dcc134ba4c?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
+812105,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0984083c0c12e5af8f"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0984083c0c12e5af8f"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0984083c0c12e5af8f/8bd19c25-c051-47f3-a41a- [...]
+812106,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0a47d31e0c2a15fd87"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0a47d31e0c2a15fd87"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/70034f92b12867f30613f25aadf6f8ca?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
+812107,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0aaa47a00c1997ea8e"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0aaa47a00c1997ea8e"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/dfc23cdb7938ba887badda2e3fac179d?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
+812108,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0b0827650c1eeb2ab6"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0b0827650c1eeb2ab6"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0b0827650c1eeb2ab6/8f882204-a169-4200-8a07 [...]
+812109,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0ba04d9c0c220c18d8"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 3, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0ba04d9c0c220c18d8"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0ba04d9c0c220c18d8/22fb069e-32f9-4ab8-be11- [...]
+812110,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0beb77320c1f821a26"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 4, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0beb77320c1f821a26"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0beb77320c1f821a26/bb1e828a-f91b-4237-85b0- [...]
+812111,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0c2490cf0c09e2e598"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0c2490cf0c09e2e598"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/21c497af87015df6beee68b1829ccd38?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812112,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ecfbd0c730ec90c1999cadf"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ecfbd0c730ec90c1999cadf"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/9f2459a1fcb78fd5c1d8b70bf3917992?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812113,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5eec896fe571480ac2ae6ede"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 5, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5eec896fe571480ac2ae6ede"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5eec896fe571480ac2ae6ede/1a02d070-08b5-43df-bd7f- [...]
+812114,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5eef5ae43589f00ab40dc60f"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5eef5ae43589f00ab40dc60f"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/133f8093dfaf54f4a11902ad59702877?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812115,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5eef5ae43589f00ab40dc611"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5eef5ae43589f00ab40dc611"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/1f32b08d4afe93746e310bd3de23ff01?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812116,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ef16f3e7e95e80a81fedc0a"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ef16f3e7e95e80a81fedc0a"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/14370ded2a7ce4669403f7f895961c58?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
+812117,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5ef3254a8624070abc590972"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5ef3254a8624070abc590972"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/24c4783eaa37f4e32874cd58dae0a4b2?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812118,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f032527e407a4001cf04d5c"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f032527e407a4001cf04d5c"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/7967062a702c1bb9fa629748ab219f37?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
+812119,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f05f5b15ee2c300233b4436"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f05f5b15ee2c300233b4436"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/69667c2c63ce892e11b9ac098e3abc4f?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812120,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f184c6dd680320021c3f8a1"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f184c6dd680320021c3f8a1"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/849b584b0be6e2ab58555276fdb4e565?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812121,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f32012eea5e2f0039284885"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f32012eea5e2f0039284885"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/64fa1e6f684df098f2c748096893fbcc?d=https%3A%2F%2Favatar-management--avatars.us-west [...]
+812122,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f32012f347294003ed909fb"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f32012f347294003ed909fb"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/d1d69b6c79d3ef5f1c92022969a15485?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812123,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f586b28df83ab007d759bfa"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f586b28df83ab007d759bfa"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/401fe3b2e223239efc2e6407ebfcf77d?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812124,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f5ede6f3242e8006f3bd173"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f5ede6f3242e8006f3bd173"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f5ede6f3242e8006f3bd173/fdfa3399-fe03-40d7-8c11- [...]
+812125,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f6c41784147d6007749dd66"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 4, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f6c41784147d6007749dd66"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f6c41784147d6007749dd66/036cd333-40df-4b47-a5ee- [...]
+812126,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f73f85158899e007055c7d3"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f73f85158899e007055c7d3"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/dc81db75677218a2dce93b7abee1a752?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812127,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5f8d380729bd8a006f5a90a0"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5f8d380729bd8a006f5a90a0"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/bf2a5e92812cfcc9c1ac29582d619a19?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812128,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5fa8b6d142ab3b006eaa6f42"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 2, ""items"": []}, ""locale"": ""zh_CN"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5fa8b6d142ab3b006eaa6f42"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fa8b6d142ab3b006eaa6f42/a000c4fd-4022-4110-8a89- [...]
+812129,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5fab870b7cfc240071f37525"", ""active"": true, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 1, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5fab870b7cfc240071f37525"", ""avatarUrls"": {""16x16"": ""https://secure.gravatar.com/avatar/8d37abf9dd0fef7ab3f9123d641d791e?d=https%3A%2F%2Favatar-management--avatars.us-west- [...]
+812130,"{""ConnectionId"":2,""BoardId"":8}","{""self"": ""https://merico.atlassian.net/rest/api/2/user?accountId=5fb48fe20d2f61006f0d0106"", ""active"": false, ""expand"": ""groups,applicationRoles"", ""groups"": {""size"": 0, ""items"": []}, ""locale"": ""en_US"", ""timeZone"": ""Asia/Shanghai"", ""accountId"": ""5fb48fe20d2f61006f0d0106"", ""avatarUrls"": {""16x16"": ""https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fb48fe20d2f61006f0d0106/3233dbe8-0b15-45fa-96f3 [...]
diff --git a/plugins/jira/e2e/snapshot_tables/_tool_jira_accounts.csv b/plugins/jira/e2e/snapshot_tables/_tool_jira_accounts.csv
index a7be9cbb..afd3adb2 100644
--- a/plugins/jira/e2e/snapshot_tables/_tool_jira_accounts.csv
+++ b/plugins/jira/e2e/snapshot_tables/_tool_jira_accounts.csv
@@ -1,31 +1,31 @@
connection_id,account_id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,account_type,name,email,avatar_url,timezone
2,557058:46121f43-e58d-4ff4-83fd-a79fb4b71b45,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812102,,app,"BigPicture - for ppm, project management",,https://secure.gravatar.com/avatar/97f7c79b50890409584990ddde1920b3?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FBM-1.png,Asia/Shanghai
2,557058:f58131cb-b67d-43c7-b30d-6b58d40bd077,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812101,,app,Automation for Jira,,https://secure.gravatar.com/avatar/600529a9c8bfef89daa848e6db28ed2d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FAJ-0.png,Asia/Shanghai
-2,5e9711ba34f7b90c0fbc37d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812103,,atlassian,Rankin Zheng,,https://secure.gravatar.com/avatar/f1e7dd8eadd9170aff5df20da45c849d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FRZ-5.png,Asia/Shanghai
-2,5ecfbd0947d31e0c2a15fd83,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812104,,atlassian,yongfeng,,https://secure.gravatar.com/avatar/fa7eb84a8ad9e90ff75a00dcc134ba4c?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-0.png,Asia/Shanghai
-2,5ecfbd0984083c0c12e5af8f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812105,,atlassian,lin.hao,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0984083c0c12e5af8f/8bd19c25-c051-47f3-a41a-f7e809e2a1b0/48,Asia/Shanghai
-2,5ecfbd0a47d31e0c2a15fd87,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812106,,atlassian,yuxiang,,https://secure.gravatar.com/avatar/70034f92b12867f30613f25aadf6f8ca?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-5.png,Asia/Shanghai
-2,5ecfbd0aaa47a00c1997ea8e,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812107,,atlassian,chao.cheng,,https://secure.gravatar.com/avatar/dfc23cdb7938ba887badda2e3fac179d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-4.png,Asia/Shanghai
-2,5ecfbd0b0827650c1eeb2ab6,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812108,,atlassian,eureka,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0b0827650c1eeb2ab6/8f882204-a169-4200-8a07-b6bd84b34e5f/48,Asia/Shanghai
-2,5ecfbd0ba04d9c0c220c18d8,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812109,,atlassian,yanghui,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0ba04d9c0c220c18d8/22fb069e-32f9-4ab8-be11-ee4e76e2e0b1/48,Asia/Shanghai
-2,5ecfbd0beb77320c1f821a26,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812110,,atlassian,Wei Qi,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0beb77320c1f821a26/bb1e828a-f91b-4237-85b0-a3ee63ef5455/48,Asia/Shanghai
-2,5ecfbd0c2490cf0c09e2e598,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812111,,atlassian,Gerile Tu,,https://secure.gravatar.com/avatar/21c497af87015df6beee68b1829ccd38?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGT-1.png,Asia/Shanghai
-2,5ecfbd0c730ec90c1999cadf,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812112,,atlassian,Dingding Zhang,,https://secure.gravatar.com/avatar/9f2459a1fcb78fd5c1d8b70bf3917992?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FDZ-1.png,Asia/Shanghai
-2,5eec896fe571480ac2ae6ede,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812113,,atlassian,Jingyang,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5eec896fe571480ac2ae6ede/1a02d070-08b5-43df-bd7f-2e7c16be5257/48,Asia/Shanghai
-2,5eef5ae43589f00ab40dc60f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812114,,atlassian,Jinglei Ren,,https://secure.gravatar.com/avatar/133f8093dfaf54f4a11902ad59702877?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJR-4.png,Asia/Shanghai
-2,5eef5ae43589f00ab40dc611,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812115,,atlassian,Emma Zou,,https://secure.gravatar.com/avatar/1f32b08d4afe93746e310bd3de23ff01?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FEZ-5.png,Asia/Shanghai
-2,5ef16f3e7e95e80a81fedc0a,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812116,,atlassian,Zhengjia Cao,,https://secure.gravatar.com/avatar/14370ded2a7ce4669403f7f895961c58?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FZC-2.png,Asia/Shanghai
-2,5ef3254a8624070abc590972,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812117,,atlassian,郭锐,,https://secure.gravatar.com/avatar/24c4783eaa37f4e32874cd58dae0a4b2?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png,Asia/Shanghai
-2,5f032527e407a4001cf04d5c,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812118,,atlassian,Han Tian,,https://secure.gravatar.com/avatar/7967062a702c1bb9fa629748ab219f37?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHT-0.png,Asia/Shanghai
-2,5f05f5b15ee2c300233b4436,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812119,,atlassian,Hezheng Yin,,https://secure.gravatar.com/avatar/69667c2c63ce892e11b9ac098e3abc4f?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHY-1.png,Asia/Shanghai
-2,5f184c6dd680320021c3f8a1,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812120,,atlassian,Shiwen Luo,,https://secure.gravatar.com/avatar/849b584b0be6e2ab58555276fdb4e565?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FSL-4.png,Asia/Shanghai
-2,5f32012eea5e2f0039284885,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812121,,atlassian,Gu Huiqin,,https://secure.gravatar.com/avatar/64fa1e6f684df098f2c748096893fbcc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGH-5.png,Asia/Shanghai
-2,5f32012f347294003ed909fb,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812122,,atlassian,Mingjing,,https://secure.gravatar.com/avatar/d1d69b6c79d3ef5f1c92022969a15485?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FM-4.png,Asia/Shanghai
-2,5f586b28df83ab007d759bfa,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812123,,atlassian,shikunming,,https://secure.gravatar.com/avatar/401fe3b2e223239efc2e6407ebfcf77d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FS-5.png,Asia/Shanghai
-2,5f5ede6f3242e8006f3bd173,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812124,,atlassian,Yi Xiang,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f5ede6f3242e8006f3bd173/fdfa3399-fe03-40d7-8c11-0d743c70bb4e/48,Asia/Shanghai
-2,5f6c41784147d6007749dd66,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812125,,atlassian,Nicholas Zheng,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f6c41784147d6007749dd66/036cd333-40df-4b47-a5ee-c42e2ccc8676/48,Asia/Shanghai
-2,5f73f85158899e007055c7d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812126,,atlassian,Carrie,,https://secure.gravatar.com/avatar/dc81db75677218a2dce93b7abee1a752?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-6.png,Asia/Shanghai
-2,5f8d380729bd8a006f5a90a0,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812127,,atlassian,jinxiu,,https://secure.gravatar.com/avatar/bf2a5e92812cfcc9c1ac29582d619a19?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJ-0.png,Asia/Shanghai
-2,5fa8b6d142ab3b006eaa6f42,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812128,,atlassian,cong wang,cong.wang@merico.dev,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fa8b6d142ab3b006eaa6f42/a000c4fd-4022-4110-8a89-0cd1deeec098/48,Asia/Shanghai
-2,5fab870b7cfc240071f37525,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812129,,atlassian,Jiewei Ye,,https://secure.gravatar.com/avatar/8d37abf9dd0fef7ab3f9123d641d791e?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJY-3.png,Asia/Shanghai
-2,5fb48fe20d2f61006f0d0106,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812130,,atlassian,Runjuu,runju.huang@merico.dev,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fb48fe20d2f61006f0d0106/3233dbe8-0b15-45fa-96f3-fba86afe140d/48,Asia/Shanghai
+2,5e9711ba34f7b90c0fbc37d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812103,,atlassian,RZ,,https://secure.gravatar.com/avatar/f1e7dd8eadd9170aff5df20da45c849d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FRZ-5.png,Asia/Shanghai
+2,5ecfbd0947d31e0c2a15fd83,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812104,,atlassian,yf,,https://secure.gravatar.com/avatar/fa7eb84a8ad9e90ff75a00dcc134ba4c?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-0.png,Asia/Shanghai
+2,5ecfbd0984083c0c12e5af8f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812105,,atlassian,hhhlll,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0984083c0c12e5af8f/8bd19c25-c051-47f3-a41a-f7e809e2a1b0/48,Asia/Shanghai
+2,5ecfbd0a47d31e0c2a15fd87,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812106,,atlassian,yx,,https://secure.gravatar.com/avatar/70034f92b12867f30613f25aadf6f8ca?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-5.png,Asia/Shanghai
+2,5ecfbd0aaa47a00c1997ea8e,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812107,,atlassian,cc,,https://secure.gravatar.com/avatar/dfc23cdb7938ba887badda2e3fac179d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-4.png,Asia/Shanghai
+2,5ecfbd0b0827650c1eeb2ab6,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812108,,atlassian,euuu,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0b0827650c1eeb2ab6/8f882204-a169-4200-8a07-b6bd84b34e5f/48,Asia/Shanghai
+2,5ecfbd0ba04d9c0c220c18d8,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812109,,atlassian,y,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0ba04d9c0c220c18d8/22fb069e-32f9-4ab8-be11-ee4e76e2e0b1/48,Asia/Shanghai
+2,5ecfbd0beb77320c1f821a26,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812110,,atlassian,qqqq,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0beb77320c1f821a26/bb1e828a-f91b-4237-85b0-a3ee63ef5455/48,Asia/Shanghai
+2,5ecfbd0c2490cf0c09e2e598,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812111,,atlassian,tu,,https://secure.gravatar.com/avatar/21c497af87015df6beee68b1829ccd38?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGT-1.png,Asia/Shanghai
+2,5ecfbd0c730ec90c1999cadf,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812112,,atlassian,d,,https://secure.gravatar.com/avatar/9f2459a1fcb78fd5c1d8b70bf3917992?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FDZ-1.png,Asia/Shanghai
+2,5eec896fe571480ac2ae6ede,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812113,,atlassian,yyy,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5eec896fe571480ac2ae6ede/1a02d070-08b5-43df-bd7f-2e7c16be5257/48,Asia/Shanghai
+2,5eef5ae43589f00ab40dc60f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812114,,atlassian,jj,,https://secure.gravatar.com/avatar/133f8093dfaf54f4a11902ad59702877?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJR-4.png,Asia/Shanghai
+2,5eef5ae43589f00ab40dc611,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812115,,atlassian,Emm,,https://secure.gravatar.com/avatar/1f32b08d4afe93746e310bd3de23ff01?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FEZ-5.png,Asia/Shanghai
+2,5ef16f3e7e95e80a81fedc0a,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812116,,atlassian,Zh,,https://secure.gravatar.com/avatar/14370ded2a7ce4669403f7f895961c58?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FZC-2.png,Asia/Shanghai
+2,5ef3254a8624070abc590972,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812117,,atlassian,ggg,,https://secure.gravatar.com/avatar/24c4783eaa37f4e32874cd58dae0a4b2?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png,Asia/Shanghai
+2,5f032527e407a4001cf04d5c,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812118,,atlassian,hh,,https://secure.gravatar.com/avatar/7967062a702c1bb9fa629748ab219f37?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHT-0.png,Asia/Shanghai
+2,5f05f5b15ee2c300233b4436,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812119,,atlassian,He,,https://secure.gravatar.com/avatar/69667c2c63ce892e11b9ac098e3abc4f?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHY-1.png,Asia/Shanghai
+2,5f184c6dd680320021c3f8a1,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812120,,atlassian,Shi,,https://secure.gravatar.com/avatar/849b584b0be6e2ab58555276fdb4e565?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FSL-4.png,Asia/Shanghai
+2,5f32012eea5e2f0039284885,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812121,,atlassian,Gu,,https://secure.gravatar.com/avatar/64fa1e6f684df098f2c748096893fbcc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGH-5.png,Asia/Shanghai
+2,5f32012f347294003ed909fb,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812122,,atlassian,mm,,https://secure.gravatar.com/avatar/d1d69b6c79d3ef5f1c92022969a15485?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FM-4.png,Asia/Shanghai
+2,5f586b28df83ab007d759bfa,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812123,,atlassian,kk,,https://secure.gravatar.com/avatar/401fe3b2e223239efc2e6407ebfcf77d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FS-5.png,Asia/Shanghai
+2,5f5ede6f3242e8006f3bd173,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812124,,atlassian,xxx,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f5ede6f3242e8006f3bd173/fdfa3399-fe03-40d7-8c11-0d743c70bb4e/48,Asia/Shanghai
+2,5f6c41784147d6007749dd66,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812125,,atlassian,Ngls,,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f6c41784147d6007749dd66/036cd333-40df-4b47-a5ee-c42e2ccc8676/48,Asia/Shanghai
+2,5f73f85158899e007055c7d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812126,,atlassian,caaa,,https://secure.gravatar.com/avatar/dc81db75677218a2dce93b7abee1a752?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-6.png,Asia/Shanghai
+2,5f8d380729bd8a006f5a90a0,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812127,,atlassian,jiu,,https://secure.gravatar.com/avatar/bf2a5e92812cfcc9c1ac29582d619a19?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJ-0.png,Asia/Shanghai
+2,5fa8b6d142ab3b006eaa6f42,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812128,,atlassian,cong,cong.wang@merico.dev,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fa8b6d142ab3b006eaa6f42/a000c4fd-4022-4110-8a89-0cd1deeec098/48,Asia/Shanghai
+2,5fab870b7cfc240071f37525,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812129,,atlassian,ye,,https://secure.gravatar.com/avatar/8d37abf9dd0fef7ab3f9123d641d791e?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJY-3.png,Asia/Shanghai
+2,5fb48fe20d2f61006f0d0106,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812130,,atlassian,juu,runju.huang@merico.dev,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fb48fe20d2f61006f0d0106/3233dbe8-0b15-45fa-96f3-fba86afe140d/48,Asia/Shanghai
diff --git a/plugins/jira/e2e/snapshot_tables/accounts.csv b/plugins/jira/e2e/snapshot_tables/accounts.csv
index 41a3c45c..0b745534 100644
--- a/plugins/jira/e2e/snapshot_tables/accounts.csv
+++ b/plugins/jira/e2e/snapshot_tables/accounts.csv
@@ -1,31 +1,31 @@
id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,email,full_name,user_name,avatar_url,organization,created_date,status
-jira:JiraAccount:2:557058:46121f43-e58d-4ff4-83fd-a79fb4b71b45,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812102,,,,"BigPicture - for ppm, project management",https://secure.gravatar.com/avatar/97f7c79b50890409584990ddde1920b3?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FBM-1.png,,,0
-jira:JiraAccount:2:557058:f58131cb-b67d-43c7-b30d-6b58d40bd077,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812101,,,,Automation for Jira,https://secure.gravatar.com/avatar/600529a9c8bfef89daa848e6db28ed2d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FAJ-0.png,,,0
-jira:JiraAccount:2:5e9711ba34f7b90c0fbc37d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812103,,,,Rankin Zheng,https://secure.gravatar.com/avatar/f1e7dd8eadd9170aff5df20da45c849d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FRZ-5.png,,,0
-jira:JiraAccount:2:5ecfbd0947d31e0c2a15fd83,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812104,,,,yongfeng,https://secure.gravatar.com/avatar/fa7eb84a8ad9e90ff75a00dcc134ba4c?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-0.png,,,0
-jira:JiraAccount:2:5ecfbd0984083c0c12e5af8f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812105,,,,lin.hao,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0984083c0c12e5af8f/8bd19c25-c051-47f3-a41a-f7e809e2a1b0/48,,,0
-jira:JiraAccount:2:5ecfbd0a47d31e0c2a15fd87,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812106,,,,yuxiang,https://secure.gravatar.com/avatar/70034f92b12867f30613f25aadf6f8ca?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-5.png,,,0
-jira:JiraAccount:2:5ecfbd0aaa47a00c1997ea8e,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812107,,,,chao.cheng,https://secure.gravatar.com/avatar/dfc23cdb7938ba887badda2e3fac179d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-4.png,,,0
-jira:JiraAccount:2:5ecfbd0b0827650c1eeb2ab6,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812108,,,,eureka,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0b0827650c1eeb2ab6/8f882204-a169-4200-8a07-b6bd84b34e5f/48,,,0
-jira:JiraAccount:2:5ecfbd0ba04d9c0c220c18d8,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812109,,,,yanghui,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0ba04d9c0c220c18d8/22fb069e-32f9-4ab8-be11-ee4e76e2e0b1/48,,,0
-jira:JiraAccount:2:5ecfbd0beb77320c1f821a26,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812110,,,,Wei Qi,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0beb77320c1f821a26/bb1e828a-f91b-4237-85b0-a3ee63ef5455/48,,,0
-jira:JiraAccount:2:5ecfbd0c2490cf0c09e2e598,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812111,,,,Gerile Tu,https://secure.gravatar.com/avatar/21c497af87015df6beee68b1829ccd38?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGT-1.png,,,0
-jira:JiraAccount:2:5ecfbd0c730ec90c1999cadf,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812112,,,,Dingding Zhang,https://secure.gravatar.com/avatar/9f2459a1fcb78fd5c1d8b70bf3917992?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FDZ-1.png,,,0
-jira:JiraAccount:2:5eec896fe571480ac2ae6ede,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812113,,,,Jingyang,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5eec896fe571480ac2ae6ede/1a02d070-08b5-43df-bd7f-2e7c16be5257/48,,,0
-jira:JiraAccount:2:5eef5ae43589f00ab40dc60f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812114,,,,Jinglei Ren,https://secure.gravatar.com/avatar/133f8093dfaf54f4a11902ad59702877?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJR-4.png,,,0
-jira:JiraAccount:2:5eef5ae43589f00ab40dc611,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812115,,,,Emma Zou,https://secure.gravatar.com/avatar/1f32b08d4afe93746e310bd3de23ff01?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FEZ-5.png,,,0
-jira:JiraAccount:2:5ef16f3e7e95e80a81fedc0a,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812116,,,,Zhengjia Cao,https://secure.gravatar.com/avatar/14370ded2a7ce4669403f7f895961c58?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FZC-2.png,,,0
-jira:JiraAccount:2:5ef3254a8624070abc590972,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812117,,,,郭锐,https://secure.gravatar.com/avatar/24c4783eaa37f4e32874cd58dae0a4b2?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png,,,0
-jira:JiraAccount:2:5f032527e407a4001cf04d5c,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812118,,,,Han Tian,https://secure.gravatar.com/avatar/7967062a702c1bb9fa629748ab219f37?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHT-0.png,,,0
-jira:JiraAccount:2:5f05f5b15ee2c300233b4436,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812119,,,,Hezheng Yin,https://secure.gravatar.com/avatar/69667c2c63ce892e11b9ac098e3abc4f?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHY-1.png,,,0
-jira:JiraAccount:2:5f184c6dd680320021c3f8a1,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812120,,,,Shiwen Luo,https://secure.gravatar.com/avatar/849b584b0be6e2ab58555276fdb4e565?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FSL-4.png,,,0
-jira:JiraAccount:2:5f32012eea5e2f0039284885,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812121,,,,Gu Huiqin,https://secure.gravatar.com/avatar/64fa1e6f684df098f2c748096893fbcc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGH-5.png,,,0
-jira:JiraAccount:2:5f32012f347294003ed909fb,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812122,,,,Mingjing,https://secure.gravatar.com/avatar/d1d69b6c79d3ef5f1c92022969a15485?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FM-4.png,,,0
-jira:JiraAccount:2:5f586b28df83ab007d759bfa,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812123,,,,shikunming,https://secure.gravatar.com/avatar/401fe3b2e223239efc2e6407ebfcf77d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FS-5.png,,,0
-jira:JiraAccount:2:5f5ede6f3242e8006f3bd173,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812124,,,,Yi Xiang,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f5ede6f3242e8006f3bd173/fdfa3399-fe03-40d7-8c11-0d743c70bb4e/48,,,0
-jira:JiraAccount:2:5f6c41784147d6007749dd66,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812125,,,,Nicholas Zheng,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f6c41784147d6007749dd66/036cd333-40df-4b47-a5ee-c42e2ccc8676/48,,,0
-jira:JiraAccount:2:5f73f85158899e007055c7d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812126,,,,Carrie,https://secure.gravatar.com/avatar/dc81db75677218a2dce93b7abee1a752?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-6.png,,,0
-jira:JiraAccount:2:5f8d380729bd8a006f5a90a0,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812127,,,,jinxiu,https://secure.gravatar.com/avatar/bf2a5e92812cfcc9c1ac29582d619a19?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJ-0.png,,,0
-jira:JiraAccount:2:5fa8b6d142ab3b006eaa6f42,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812128,,cong.wang@merico.dev,,cong wang,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fa8b6d142ab3b006eaa6f42/a000c4fd-4022-4110-8a89-0cd1deeec098/48,,,0
-jira:JiraAccount:2:5fab870b7cfc240071f37525,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812129,,,,Jiewei Ye,https://secure.gravatar.com/avatar/8d37abf9dd0fef7ab3f9123d641d791e?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJY-3.png,,,0
-jira:JiraAccount:2:5fb48fe20d2f61006f0d0106,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812130,,runju.huang@merico.dev,,Runjuu,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fb48fe20d2f61006f0d0106/3233dbe8-0b15-45fa-96f3-fba86afe140d/48,,,0
+jira:JiraAccount:2:557058:46121f43-e58d-4ff4-83fd-a79fb4b71b45,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812102,,,"BigPicture - for ppm, project management","BigPicture - for ppm, project management",https://secure.gravatar.com/avatar/97f7c79b50890409584990ddde1920b3?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FBM-1.png,,,0
+jira:JiraAccount:2:557058:f58131cb-b67d-43c7-b30d-6b58d40bd077,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812101,,,Automation for Jira,Automation for Jira,https://secure.gravatar.com/avatar/600529a9c8bfef89daa848e6db28ed2d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FAJ-0.png,,,0
+jira:JiraAccount:2:5e9711ba34f7b90c0fbc37d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812103,,,RZ,RZ,https://secure.gravatar.com/avatar/f1e7dd8eadd9170aff5df20da45c849d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FRZ-5.png,,,0
+jira:JiraAccount:2:5ecfbd0947d31e0c2a15fd83,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812104,,,yf,yf,https://secure.gravatar.com/avatar/fa7eb84a8ad9e90ff75a00dcc134ba4c?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-0.png,,,0
+jira:JiraAccount:2:5ecfbd0984083c0c12e5af8f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812105,,,hhhlll,hhhlll,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0984083c0c12e5af8f/8bd19c25-c051-47f3-a41a-f7e809e2a1b0/48,,,0
+jira:JiraAccount:2:5ecfbd0a47d31e0c2a15fd87,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812106,,,yx,yx,https://secure.gravatar.com/avatar/70034f92b12867f30613f25aadf6f8ca?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FY-5.png,,,0
+jira:JiraAccount:2:5ecfbd0aaa47a00c1997ea8e,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812107,,,cc,cc,https://secure.gravatar.com/avatar/dfc23cdb7938ba887badda2e3fac179d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-4.png,,,0
+jira:JiraAccount:2:5ecfbd0b0827650c1eeb2ab6,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812108,,,euuu,euuu,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0b0827650c1eeb2ab6/8f882204-a169-4200-8a07-b6bd84b34e5f/48,,,0
+jira:JiraAccount:2:5ecfbd0ba04d9c0c220c18d8,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812109,,,y,y,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0ba04d9c0c220c18d8/22fb069e-32f9-4ab8-be11-ee4e76e2e0b1/48,,,0
+jira:JiraAccount:2:5ecfbd0beb77320c1f821a26,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812110,,,qqqq,qqqq,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5ecfbd0beb77320c1f821a26/bb1e828a-f91b-4237-85b0-a3ee63ef5455/48,,,0
+jira:JiraAccount:2:5ecfbd0c2490cf0c09e2e598,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812111,,,tu,tu,https://secure.gravatar.com/avatar/21c497af87015df6beee68b1829ccd38?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGT-1.png,,,0
+jira:JiraAccount:2:5ecfbd0c730ec90c1999cadf,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812112,,,d,d,https://secure.gravatar.com/avatar/9f2459a1fcb78fd5c1d8b70bf3917992?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FDZ-1.png,,,0
+jira:JiraAccount:2:5eec896fe571480ac2ae6ede,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812113,,,yyy,yyy,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5eec896fe571480ac2ae6ede/1a02d070-08b5-43df-bd7f-2e7c16be5257/48,,,0
+jira:JiraAccount:2:5eef5ae43589f00ab40dc60f,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812114,,,jj,jj,https://secure.gravatar.com/avatar/133f8093dfaf54f4a11902ad59702877?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJR-4.png,,,0
+jira:JiraAccount:2:5eef5ae43589f00ab40dc611,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812115,,,Emm,Emm,https://secure.gravatar.com/avatar/1f32b08d4afe93746e310bd3de23ff01?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FEZ-5.png,,,0
+jira:JiraAccount:2:5ef16f3e7e95e80a81fedc0a,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812116,,,Zh,Zh,https://secure.gravatar.com/avatar/14370ded2a7ce4669403f7f895961c58?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FZC-2.png,,,0
+jira:JiraAccount:2:5ef3254a8624070abc590972,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812117,,,ggg,ggg,https://secure.gravatar.com/avatar/24c4783eaa37f4e32874cd58dae0a4b2?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png,,,0
+jira:JiraAccount:2:5f032527e407a4001cf04d5c,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812118,,,hh,hh,https://secure.gravatar.com/avatar/7967062a702c1bb9fa629748ab219f37?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHT-0.png,,,0
+jira:JiraAccount:2:5f05f5b15ee2c300233b4436,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812119,,,He,He,https://secure.gravatar.com/avatar/69667c2c63ce892e11b9ac098e3abc4f?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FHY-1.png,,,0
+jira:JiraAccount:2:5f184c6dd680320021c3f8a1,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812120,,,Shi,Shi,https://secure.gravatar.com/avatar/849b584b0be6e2ab58555276fdb4e565?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FSL-4.png,,,0
+jira:JiraAccount:2:5f32012eea5e2f0039284885,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812121,,,Gu,Gu,https://secure.gravatar.com/avatar/64fa1e6f684df098f2c748096893fbcc?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FGH-5.png,,,0
+jira:JiraAccount:2:5f32012f347294003ed909fb,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812122,,,mm,mm,https://secure.gravatar.com/avatar/d1d69b6c79d3ef5f1c92022969a15485?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FM-4.png,,,0
+jira:JiraAccount:2:5f586b28df83ab007d759bfa,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812123,,,kk,kk,https://secure.gravatar.com/avatar/401fe3b2e223239efc2e6407ebfcf77d?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FS-5.png,,,0
+jira:JiraAccount:2:5f5ede6f3242e8006f3bd173,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812124,,,xxx,xxx,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f5ede6f3242e8006f3bd173/fdfa3399-fe03-40d7-8c11-0d743c70bb4e/48,,,0
+jira:JiraAccount:2:5f6c41784147d6007749dd66,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812125,,,Ngls,Ngls,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5f6c41784147d6007749dd66/036cd333-40df-4b47-a5ee-c42e2ccc8676/48,,,0
+jira:JiraAccount:2:5f73f85158899e007055c7d3,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812126,,,caaa,caaa,https://secure.gravatar.com/avatar/dc81db75677218a2dce93b7abee1a752?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FC-6.png,,,0
+jira:JiraAccount:2:5f8d380729bd8a006f5a90a0,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812127,,,jiu,jiu,https://secure.gravatar.com/avatar/bf2a5e92812cfcc9c1ac29582d619a19?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJ-0.png,,,0
+jira:JiraAccount:2:5fa8b6d142ab3b006eaa6f42,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812128,,cong.wang@merico.dev,cong,cong,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fa8b6d142ab3b006eaa6f42/a000c4fd-4022-4110-8a89-0cd1deeec098/48,,,0
+jira:JiraAccount:2:5fab870b7cfc240071f37525,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812129,,,ye,ye,https://secure.gravatar.com/avatar/8d37abf9dd0fef7ab3f9123d641d791e?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FJY-3.png,,,0
+jira:JiraAccount:2:5fb48fe20d2f61006f0d0106,"{""ConnectionId"":2,""BoardId"":8}",_raw_jira_api_users,812130,,runju.huang@merico.dev,juu,juu,https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/5fb48fe20d2f61006f0d0106/3233dbe8-0b15-45fa-96f3-fba86afe140d/48,,,0