Filter json output in azure synapse-pipeline?

Advertisements I’m creating a Pipeline in Azure Synapse Analytics using the synapse pipeline to get the content of a Rest-API call. Before the call I have to get the bearer token. While using the web activity to get the bearer token for an Rest-API Call, I get the bearer token in a format like {"access_token":"Sample-Bearer-Token","token_type":"bearer","expires_in":999999}.… Read More Filter json output in azure synapse-pipeline?