自定义函数: jsonToVars ( JSON ; scope )

May 24, 2020

函数功能描述

来源:

作者:

作者原述:

猫壹佰描述:

将JSON转化成参数.

scope为global时为全局参数.

测试文档下载:

调用范例

jsonToVars ( JSONSetElement ( "" ; "foo" ; "bar" ; "" ) ; "local" )

返回结果

VOID ($foo = "bar")

函数内容

/**
 * ==================================================================
 * jsonToVars ( JSON ; scope )
 *
 * PARAMETERS:
 *            @JSON (text) properly formatted JSON string. 
 *            @scope (enum) local, global 
 * RETURNS:
 *            (void) key values are the variable names and each key is assigned the associated value
 *           
 * DEPENDENCIES:
 *            FileMaker 18 or higher
 * PURPOSE:
 *            use to pass in JSON objects to convert to FileMaker variables
 *           
 * NOTES:
 *            none
 * VERSION: 
 *		1.0
 * AUTHOR:
 *            Rob Poelking rob@excelisys.com
 * REVISIONS:
 *		Rob Poelking 5/20/20 - initial release
 * ==================================================================
 *
 */


While ( [
		~json =JSON ; 
		~i = Null ;
		~scope = scope ;
		~s = If ( ~scope = "global" ; "$$" ; "$" ) ;
		~keys = JSONListKeys ( ~json ; "" ) ;
		~len = ValueCount ( ~keys ) ;
		~eval = "Let ([S][thiskey] = [thisvalue];\"\")" ;
		~void = "" ;
		~fn = ""
	] ;
	~i < ~len ; 
	[
		~i = ~i + 1 ;
		~thiskey = GetValue ( ~keys ; ~i );
		~fn =
		Substitute (
			~eval ; [ "[S]" ; ~s ] ; [ "[thiskey]" ; GetValue ( ~keys ; ~i ) ] ; [ "[thisvalue]" ; Quote ( JSONGetElement ( ~json ;  ~thiskey ) ) ]
		) ;
		~void = Evaluate ( ~fn )
	] ;
	 ~void
)

当前页面使用FileMaker生成发布, 更新于2021年3月22日0时5分10秒

Back to blog

Your cart is empty

Your cart

Estimated total

自定义函数: jsonToVars ( JSON ; scope )

Country/region