Skip to main content
Topics#Salesforce DeveloperQuestion de Abdul Yashar
Abdul Yashar (TechnoRUCS) a posé une question dans #Salesforce Developer
27 sept. 2022, 15:40

I'm getting an response in the form of csv(comma separated value) string when I'm making callout to an API,

I need to convert that into a JSON format using the CSV string. I've tried certain methods to convert that CSV string to JSON in an asynchronous way (Batchable, Queueable). I'm getting CPU time limit exceeded. Are there any other ways to convert the CSV string to JSON,  

NOTE: The Excel records contain 40k.

1 réponse
  1. Trevor Krieg (Corelight)
    27 sept. 2022, 16:20

    ive had similar issues. If you are able to use a 3rd party app like AWS flow thats a great option but if you cant here are some formulas that may help you to convert it using an apex class:

     JSON.serialize(contJsonList)

     

    If all else fails download the CVS and then just rename ending in .json

Rédiger une réponse...
0/9000