Json question help

Development Web Sources Discussion
#1

I have this code:

but is shows the "," after the last name, what is the best way to remove this?

the json is:

#2

I don't know exactly how to solve this in a Web Source.
The solution would be to check if the last row in the foreach-loop is reached.
Only add the ", " if this is NOT the last iteration/row in this loop.

#3

Yes but how? maybe the code is better in other way?

#4

Hi,
You could achieve this by

ifoutput "composer"
say ", "
endif
ifnot "0"
json_select "names"
json_select "en"
sayrest
endif
In general, if there was a command to bring the content of a buffer to the "current" one, that would solve many similar issues.
E.g. here, "currentbuffer" is the input buffer populated from WS when consuming the input stream (json or text). "Composer" has a trailing comma.
set "currentbuffer"
outputto "currentbuffer"
sayoutput "composer"
set "composer"
regexpreplace "[,\s]+$" ""
gotochar 1
sayrest
We bring buffer "composer" to the input buffer, we process it there and then move it back (Say command).
I had raised similar issue several years back.
Because of this "missing" functionality I had stopped some heavy WS developments had spent endless days.
Only @Florian could help in this case, if he can anyway.

#5

i cannot get this solution to work, can you give me an hint?

#6

Can you please share your discogs release id?

#7

do you mean the album example in the first post?: 893369

#8

What I wrote initially should work (if collected tag is not empty then add separator to it).
I would like to know the exact source and id you use for your example.
It is not Discogs. Discogs do don't use tag "composers" AFAIK.

#9

The source i use is http://vgmdb.info/

http://vgmdb.info/album/73784

In Json: http://vgmdb.info/album/73784?format=json

the websource:

VGMdb#Search by &Album JSON.src (4.8 KB)

#10

Use this section for "composers"
You may need to do the same for all multivalue tags.
The key is ifoutput "composer" ... say ", " ... endif.

# Composers
outputto "composer"
json_foreach "composers"
	ifoutput "composer"
		say ", "
	endif
	json_select "names"
	json_select "en"
	sayrest
json_foreach_end