MakAgent在线文档

Appearance

数据映射 ​

对变量或表格中的数据进行结构转换和字段映射。

配置选项 ​

数据源 ​

选择要映射的数据来源：

  • 变量
  • 表格

数据映射 ​

通过点表示法将源字段与目标字段进行匹配。一个源字段可以对应多个目标字段。

示例： 原始数据：

json
[
	{
		"address": "2204 Volutpat Rd.",
		"name": "Palmer Porter",
		"phone": "(251) 595-5203",
		"email": "phasellus.dolor@aol.org",
		"postalZip": "8517",
		"country": "United States"
	},
	{
		"address": "2741 Dis Rd.",
		"name": "Byron Bowers",
		"phone": "(563) 717-9312",
		"email": "mattis.ornare@outlook.couk",
		"postalZip": "5612",
		"country": "Costa Rica"
	},
	{
		"address": "Ap #923-7718 Sed Rd.",
		"name": "Joseph Waller",
		"phone": "1-897-102-6811",
		"email": "cras.pellentesque@outlook.edu",
		"postalZip": "38-251",
		"country": "Belgium"
	}
]
[
	{
		"address": "2204 Volutpat Rd.",
		"name": "Palmer Porter",
		"phone": "(251) 595-5203",
		"email": "phasellus.dolor@aol.org",
		"postalZip": "8517",
		"country": "United States"
	},
	{
		"address": "2741 Dis Rd.",
		"name": "Byron Bowers",
		"phone": "(563) 717-9312",
		"email": "mattis.ornare@outlook.couk",
		"postalZip": "5612",
		"country": "Costa Rica"
	},
	{
		"address": "Ap #923-7718 Sed Rd.",
		"name": "Joseph Waller",
		"phone": "1-897-102-6811",
		"email": "cras.pellentesque@outlook.edu",
		"postalZip": "38-251",
		"country": "Belgium"
	}
]

使用如下映射规则：

数据映射

转换后的数据：

json
[
	{
		"email": "phasellus.dolor@aol.org"
		"full_name": "Palmer Porter",
		"address": {
			"street": "2204 Volutpat Rd.",
			"postalZip": "8517",
			"country": "United States"
		},
	},
	{
		"email": "mattis.ornare@outlook.couk",
		"full_name": "Byron Bowers",
		"address": {
			"street": "2741 Dis Rd.",
			"postalZip": "5612",
			"country": "Costa Rica"
		},
	},
	{
		"email": "cras.pellentesque@outlook.edu",
		"full_name": "Joseph Waller",
		"address": {
			"street": "Ap #923-7718 Sed Rd."
			"postalZip": "38-251",
			"country": "Belgium"
		}
	}
]
[
	{
		"email": "phasellus.dolor@aol.org"
		"full_name": "Palmer Porter",
		"address": {
			"street": "2204 Volutpat Rd.",
			"postalZip": "8517",
			"country": "United States"
		},
	},
	{
		"email": "mattis.ornare@outlook.couk",
		"full_name": "Byron Bowers",
		"address": {
			"street": "2741 Dis Rd.",
			"postalZip": "5612",
			"country": "Costa Rica"
		},
	},
	{
		"email": "cras.pellentesque@outlook.edu",
		"full_name": "Joseph Waller",
		"address": {
			"street": "Ap #923-7718 Sed Rd."
			"postalZip": "38-251",
			"country": "Belgium"
		}
	}
]

  • 分配给变量
    是否将映射的数据分配给 变量 。

    • 变量名称
      用于分配映射数据的变量的名称。

  • 插入表格
    是否将映射的数据插入到表格中。

    • 选择列
      将插入映射数据的列。