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&parameter2=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?

• Share
• Tweet
• Share
• Pin
• Email

 

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&parameter2=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?

 

• A) ARRAY

 

• B) MAP

 

• C) NUMBERFORMAT

 

• D) INDEXOF

 

• E) All of the above

 

• F) None of the above

 

• Share
• Tweet
• Share
• Pin
• Email