web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Oracle Parse\Convert Json
Power Automate
Suggested Answer

Oracle Parse\Convert Json

(0) ShareShare
ReportReport
Posted on by 8
The Oracle sql script has this result formatted this way:
 
{
  "OutputParameters": {}
  "ResultSets": {
    "Table1": [
      {
        "CUSTOMERID": "905"
        "TAXID": "905"
        "CUSTOMERNAME": "Union"
        "FIRSTNAME": null
        "MIDDLENAME": null
        "LASTNAME": null
        "HOMEPHONE": null
        "BUSINESSPHONE": "80058729"
        "MOBILEPHONE": null
        "EMAILADDRESS": null
        "ADDRESS1": "PO Box 1112"
        "ADDRESS2": null
        "CITYNAME": "City"
        "STATECD": "State"
        "ZIPCD": "98005"
        "CIF": null
        "CTRYCD": "USA"
        "group": null
        "MEMBERNBR": 77255.0
      }
 
How do I format this into a tab delimited file csv without the header by column? So, basically the data result will show horizontally without the headers (CustomerID, TaxID, CustomerName....etc)
Screenshot 2026-01-12 164321.png
I have the same question (0)
  • Suggested answer
    Srini007 Profile Picture
    3,483 Super User 2026 Season 1 on at
     
    Check below screenshot for your reference, below I tool only first two columns so you only see CUSTOMERID and TAXID in the below screenshot, you can put remaining if you want, Let me know if you have any difficulties
     
     
     

    (If this answers your question you can mark as Answered and give it a Like)

    Regards,
    Srini

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard