Klipfolio Partner Certification Exam

  1. You’ve written MAPFLAT function as follows to paginate 10 pages of a dynamic datasource: MAPFLAT( CUMULATIVE(REPEAT(1,10)), “api_page_no”, @A:A). The api query that returns @A:A correpsonds to https://somebaseurl.com/endpoint?parameter1=value1¶meter2=value2 &page={props.api_page_no}. From this api’s documentation, you find out that page number in the query must be of the format “page=1” NOT “page=1.0”. What function is missing within your formula to ensure it executes the pagination correctly?
  2. Consider the following scenario: You have a table Klip where column 1 has the following data ARRAY(“b,a,a,a,b,b,b,c,c”) with a group action applied. What will you see if you make a formula reference (!column 1) and a results reference (&column 1) to column 1?
  3. For the following label component: with these properties: What would formulas X and Y give you? X:!Label Y:&Label