containerAttributesAsJSON ( container ; attributeName )

Returns container attributes as JSON array with added filetype if file has file extension

Be the first to rate this function Log in to vote

Jonni™ - Show more from this author

Sample input:

containerAttributesAsJSON ( "myTable::myContainerField" ; "all" )

Sample output:

{
"External Files" : "0",
"External Size" : "0",
"File Size" : "81226",
"Filename" : "myFile.pdf",
"Height" : "1024",
"Internal Size" : "81281",
"MD5" : "D4DDDF27D10F8326E0829814D6456FBC",
"Storage Type" : "Embedded",
"Width" : "752",
"filetype" : "pdf"
}

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

While ( [ 

	~array = GetContainerAttribute ( container ; attributeName ) ;
	~count = ValueCount ( ~array ) ;
	~pos = "" ;
	~line = "" ;
	~result = "" ; 
	~i = 1 

] ; 

	~i ≤ ~count

; [ 

	~line = GetValue ( ~array ; ~i ) ;
	~pos = Position ( ~line ; ":" ; 1 ; 1 );
	~result = Case ( Left ( ~line ; 1 ) = "[" ; ~result ; IsEmpty ( ~line ) ; ~result ; 

		JSONSetElement ( ~result ; Left ( ~line ; ~pos - 1 ) ; Right ( ~line ; Length ( ~line ) - ~pos - 1 ) ; 1 )

		) ;
	~i = ~i + 1

] ; 

	JSONSetElement ( ~result ; "filetype" ; Right ( JSONGetElement ( ~result ; "Filename" ) ; Length ( JSONGetElement ( ~result ; "Filename" ) ) - Position ( JSONGetElement ( ~result ; "Filename" ) ; "." ; 1 ; PatternCount ( JSONGetElement ( ~result ; "Filename" ) ; "." ) ) ) ; 1 )

)

// Returns container attributes as JSON array with added filetype if file has file extension
// Example : ContainerAttributesAsJSON ( myTable::myContainerField ; "all" )
// Written by: jonni@me.com
// V 1.2

Wraps the response of GetContainerAttribute in a JSON array.
Adds a filetype object if the file has an extension in the filename separated by a period.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

containerAttributesAsJSON ( container ; attributeName )

Comments

Support this website.

Support this website.