generate query full json file for publi