Power Platform Community Forum Thread Details

I have a API which returns the following in Table datatype.

[
  {
    "@odata.etag": "",
    "Cabin_Decorations__c": 1.0,
    "CreatedById": "******",
    "CreatedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-13T11:59:58.0000000Z"
    },
    "Custom_Notes__c": "Loves chocolate cake",
    "Customer_Testimonials__c": "\"The decorations and cake were perfect! Thank you for the effort!\"",
    "Dinner_Reservation__c": 1.0,
    "Id": "******",
    "IsDeleted": false,
    "ItemInternalId": "******",
    "LastActivityDate": null,
    "LastModifiedById": "******",
    "LastModifiedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    },
    "LastReferencedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    },
    "LastViewedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    },
    "Name": "******",
    "Occasion_Type__c": "Birthday",
    "Occasions_Image_URL__c": "******",
    "OwnerId": "******",
    "Special_Inclusions__c": "Birthday cake, room décor",
    "Suggested_Cabin_Type__c": "Balcony Suite",
    "SystemModstamp": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    }
  },
  {
    "@odata.etag": "",
    "Cabin_Decorations__c": 1.0,
    "CreatedById": "******",
    "CreatedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-13T11:59:58.0000000Z"
    },
    "Custom_Notes__c": "Prefers a quiet dinner setting",
    "Customer_Testimonials__c": "\"The private dinner setup was magical—highly recommend!\"",
    "Dinner_Reservation__c": 1.0,
    "Id": "******",
    "IsDeleted": false,
    "ItemInternalId": "******",
    "LastActivityDate": null,
    "LastModifiedById": "******",
    "LastModifiedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    },
    "LastReferencedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    },
    "LastViewedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    },
    "Name": "******",
    "Occasion_Type__c": "Anniversary",
    "Occasions_Image_URL__c": "******",
    "OwnerId": "******",
    "Special_Inclusions__c": "Champagne, romantic dinner",
    "Suggested_Cabin_Type__c": "Oceanview Suite",
    "SystemModstamp": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    }
  },
  {
    "@odata.etag": "",
    "Cabin_Decorations__c": 1.0,
    "CreatedById": "******",
    "CreatedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-13T11:59:58.0000000Z"
    },
    "Custom_Notes__c": "Special honeymoon photo shoot",
    "Customer_Testimonials__c": "\"An unforgettable honeymoon! The spa and surprises were amazing.\"",
    "Dinner_Reservation__c": 1.0,
    "Id": "******",
    "IsDeleted": false,
    "ItemInternalId": "******",
    "LastActivityDate": null,
    "LastModifiedById": "******",
    "LastModifiedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    },
    "LastReferencedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    },
    "LastViewedDate": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    },
    "Name": "******",
    "Occasion_Type__c": "Honeymoon",
    "Occasions_Image_URL__c": "******",
    "OwnerId": "******",
    "Special_Inclusions__c": "Spa treatments, private photo shoot",
    "Suggested_Cabin_Type__c": "Honeymoon Suite",
    "SystemModstamp": {
      "$kind": "DateTimeNoTimeZoneDataValue",
      "value": "2024-12-18T08:03:58.0000000Z"
    }
  }
]

This data is stored in Topic.VarValue. The requirement is simple, I need to convert this variable which is in table format to JSON format, I can use this to pass into a AI Builder custom prompt within my topic (it only accepts string as input)

thanks in advance.

Categories:

General

How to parse Table type to JSON type in Copilot Studio Topics

Helpful resources

News and Announcements

Quick Links

November 2024 Newsletter…

Community Update Oct 28…

Tuesday Tip #9 Get Recognized…

more Community News

Leaderboard

Featured topics

Product updates