Unanswered

Covert JSON to string

(0) Share

Report

Posted on by Cozey

I'm making an http request to zendesk from the copilot. This request returns a JSON, which I can only set as a variable of type any. How can I take this variable and convert it to a string? I need the http response as a string to provide it to other parts of the copilot and other http requests, and i'm getting errors when trying to do it from my 'any' variable.

Categories:

General

All responses (2)

Answers (0)

citron-truc 389 on at

Like (0)

Report

Re: Covert JSON to string

If you want a string as an output, I guess you can join all the list element or something like that.
citron-truc 389 on at

Like (0)

Report

Re: Covert JSON to string

Good morning,

I hope you are doing well. I had a similar problem where I had made an http call and got a json which contained a list of values of the form:
kind: Record
properties:
@OData.context: String
value:
type:
kind: Table
properties:
@OData.type: String
classification: Blank
createdDateTime: String
creationOptions:
type:
kind: Table

deletedDateTime: Blank
description: Blank
displayName: String
expirationDateTime: Blank
groupTypes:
type:
kind: Table

id: String
isAssignableToRole: Blank
mail: String
mailEnabled: Boolean
mailNickname: String
membershipRule: Blank
membershipRuleProcessingState: Blank
onPremisesDomainName: Blank
onPremisesLastSyncDateTime: Blank
onPremisesNetBiosName: Blank
onPremisesProvisioningErrors:
type:
kind: Table

onPremisesSamAccountName: Blank
onPremisesSecurityIdentifier: Blank
onPremisesSyncEnabled: Blank
preferredDataLocation: Blank
preferredLanguage: Blank
proxyAddresses:
type:
kind: Table
properties:
Value: String

renewedDateTime: String
resourceBehaviorOptions:
type:
kind: Table

resourceProvisioningOptions:
type:
kind: Table

securityEnabled: Boolean
securityIdentifier: String
serviceProvisioningErrors:
type:
kind: Table

theme: Blank
visibility: Blank

In order to get a list of all ids, I used the following formula :