469,913 Members | 2,107 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,913 developers. It's quick & easy.

What is the best way to operate on JSON - pulling, adding and doing a trigger?

Ladies and gentlemen ,i learn by doing simple examples but every time when try to extract some data yourself, rework it and display it as I want it, I have a problem.

I never know when and how and what I have to use to get a typical json
Expand|Select|Wrap|Line Numbers
  1. [
  2.     { item1:
  3.      [ '1',
  4.        '2nd',
  5.        '3thv'
  6.     ] },
  7.     { item2:
  8.      [ '1',
  9.        '2nd',
  10.        '3th'
  11.      ] }  
  12. ]
  13.  
I'd like to format it so that I can delete it into a csv file


My second question is how the easiest way to trigger an event

For example. Gets a get to the json with the X:Y data, then i want the Y value to run a function that returns the new get to another enpoint with a value that depends on X
Aug 1 '20 #1
5 2810
isladogs
316 Expert Mod 256MB
There really is no such thing as a typical JSON.
The JSON file syntax allows for a wide range of valid files, some of which are 'legal' but poorly constructed. This can make handling certain JSON files quite tricky

I can't provide links here but the following may be helpful
1. There are free online converters that allow you to convert e.g USON to CSV
2. I have an app on my website which is used for analysing the structure of JSON files then transforming the file for importing into Access as one or more normalised tables.
3. Excel has a very powerful built in feature originally called Power Query but now Get & Transform. This does the same as my Access app but the feature isn't available in Access unfortunately.

Suggest you do an online search for each of these or send me an PM if you need more info.

I have no experience of working with JSON using JavaScript

Sorry but I have no idea what your second question means
Aug 1 '20 #2
dev7060
534 Expert 512MB
I never know when and how and what I have to use to get a typical json
I'd like to format it so that I can delete it into a csv file
Make changes in the code to parse the obtained json correctly. Once that is achieved, conversion to csv can be done.
Aug 1 '20 #3
@dev7060
but how am I supposed to parse it ?
Aug 2 '20 #4
isladogs
316 Expert Mod 256MB
Did you investigate any of the three suggestions I made?
You can also find JSON parsing code on e.g. GitHub
Aug 2 '20 #5
dev7060
534 Expert 512MB
but how am I supposed to parse it ?
By writing some code. What is the progress so far?
Aug 2 '20 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

20 posts views Thread by O Ransen | last post: by
9 posts views Thread by Eqbal | last post: by
2 posts views Thread by Bob Stearns | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.