Manipulating JSON Data from Bubble

Need help APIs
1

I am looking to transform data that is returned from my API. I am calling an API that has a datetime field that formats the data in the following format:

YYYY-MM-DDThh:mm:ss.sssZ

I would like to transform this data to represent the below format:

MM/DD/YYYY and then subtract 1 day from this.

Can I do this sort of data transformation using bubble or should I leverage AWS Lambda + API Gateway to handle the transformation of the data?

2

@matthew.metros

date’s value :formatted as :days -1

3

Is there a custom application in bubble for transforming data? What is the module / feature performing complex logic across all data types