Web Query with Dynamic URL

[alpercalik]

Hello,

My issue was running a web query with a dynamic URL. The URL has 3 variables which can be entered in A1,A2,A3 cells. I created an IQY file with notepad and placed it in Queries folder:

WEB
1
http://edb.volvo.net/cgi-bin/wis2/vehspec5.cgi?func=1&svariants=&pkl=04&f1=["f1","Select The Country"]&f2=["f2","Select the Year"]&f3=["f3","Select FO"]

Selection=2
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False

When i run Import Data from Data menu in Excel it asks me those 3 variables to be entered or selected from cells. So it downloads the data into my Excel sheet. I also set the parameters for those variables to be taken from the related cells. So it runs fastly and smotthly and the only thing i need to do is Refreshing the query.

But i realized that it doesn't download and paste all of the data i need from that source.
Is it "Data Range Properties" making it or something else i missed? I will be very happy if you can help me on this issue.

Thanks in advance.

 

[alpercalik]

/Bump

What i need to know is why my query isn't taking the all data part i selected. It comes partially and it's nothing for me without having it completely.

 

[alpercalik]

The whole list that i want to get from web source is like this :

  04-TLV   FM 42T B MAT-GREY UXFUEL   ULADDER  USPOTP   UDECALTP
 FFL1295  SPWCD-EC UBULBKIT ULAMPIN  UGAUGETP UCHAINS  VERSION2
 EMBL-MO  WSTUD-S  UEGR     TYPE-FM  UTRAPACK ULOADIND 4*2     
 DASH-BLU CABPT-R1 TRACTOR  RC-ROUGH GCW56.0  CONC-BAS UALARMB 
 ENG-VE13 VH4.0    UWARVEST UBUNKBOX UAIRBAG  EXHP-SAC SUNV-SMO
 UAPF     USIGNSWC UCOMEQ   SUPH-TEX SEATBRI  AUXSW-6  WRITEPAD
 USIGNS   TELECARD UFUFIWH  STWPOS-L RAA11    DIMPLATE UPAXLE  
 VW2600   MATT-PRE FA-HIGH  FRAX-UNI FAL7.1   FATYPE71 FAP3040 
 FAA10    UTAXLE   RAL13    RAD-A4   RAP6740  LUGOP-BS INST-HIG
 AUD-BAS  UADR     VERS-BAS CHH-STD  UBSR     URSTS    D13A400 
 VOLENG   ETOR2040 CHOSE-RU EBR-VEB  BUGNET   RADI-NAR VAL-BAS3
 WTD-DUAL UWCAP    CLUT-BAS COOLC48  USPEEDDU SPEED90  CRUISEC 
 FAN-VISE UFUELFP  AIRIN-HI FUELSEC2 FUELTFIL AF-E     ULFUEL  
 RFUEL530 FUELTS71 TNK-SING FTANK-AL FCAP-L   MUF-HOR  EXD-LEFT
 EXSH-ST  UEXSTACK UEAS     EM-EC01  NR-80EC  ACL1ST   URPLCR  
 ENGPROT  UPSCOOL  24V      TRANSF-H UTRACON  UTABS    UACC    
 UPHONE   LOWB-STD UFLASHL  HL-ASYMR DETECT-S HORN-ELS USWS    
 HORN-JER UELCEPK  BBOX-L   BBOXC-BA 2BATT225 UHOOKSC  UFMS    
 UADTL    URAG     TWEETER  URTOLL   EST-AID  TL-BAS   MAINSW-M
 FOGL-WC  DRIVL2EC FUP      UHLADJ   HL-CLEAN IMMOBIL  UIDLAMP 
 MARKL-SR UALTTR   UDOUTLET RLIGHT-W UWPREBOC WL-TA1W  UWARNLIG
 SPG-KM   ESUNV2P  ASCOP120 UPSCAT   SBD-BLAC SBP-BLAC UEPTT   
 CIRCP-F  TEMP-AMB TEMP-TRA UGAUGEAM 24ALT-HB SI-GRAF  1DAY-STD
 CALI-EC  DIFL-TUR DISL-NUM UTIS     UKEYB    HL-BASIC T-PFLAT 
 OILS-PL  BATTD128 RSAP-BAS TRAP-BAS UEBRAS   URSTL    TURB-B  
 SBCC-B   ADH-HIGH CS43B-OR CCV-O    UFAS     UTAD     MECHTRAN
 GSS-SRC  VT2214B  TRAN-V   SRED-V   RS1356SV RACAS-CA GENRAX  
 V2214    LIVING0  AUDIO0   AIRFL0   EC-REG   UL-FUEL  R530A71 
 LNGTUR   MIRSTD   TUFME3   CABLEV0  1DAYEC   TUR-MSP  USAFEP  
 FM42T400 STDHCM   EUDRPA1  RFUEL    WL-ST    UAXLE    TEXTILE 
 TTRCON77 ESH-LEFT UDFP     RAT3.10  PROPS-L  UPLF     UPLS    
 PLM1700  UWEDGE   PSM-GKN  PROP-STD UPSBRKT1 UADTM    UPSBRKT2
 UADTP    UPSBP1   UPSBP2   DL-FULL  MPRO-FXS UPTER    TC-MWO  
 UPTOENGR PTR-DH   UPTOFLYW BSYS-EBS UHPE     DBRDUST  AUXPARK 
 DASHB-BX BRCYL-LO BRAKE-DV DASHP-BX BRV-V1   BRAD-BAS BRCYL-V1
 ATANK-V1 ATNK-GEN UADTR    UATNKRUB UADTS    BF-DIBAS BR-DIBAS
 FBRA-D43 ISUNF-B  RBRA-D43 BRADJ-A  AIRDRY-E TAS-ANA  2COM1080
 FBREG-E  SIL-BRV  URETARD  LOADSV   TRBRAKE1 TCP-BMC  TECT-SBP
 TRBR-EBS ABS-EBS  ABSM-GEN INLI-BAS STG20.0  PSS-SING SMCONT  
 UFRACLOS RF-TAPER FRAME77  FRAMELOW RFL825   URUP     FST-PAR 
 RST-AIR2 FSS-LEAF RSS-AIR  FSTAB2   UALCOLOC USUP     RSTAB1  
 RSHABS   FRH-210  RRH-240  URALIM   SUSPL-EC ULINER   WTF-D335
 WTD-D335 WMF-ST   WMD-ST   WDF900   WDD900   WPRING-P WTDF22.5
 WTDD22.5 UIDLMPSW UTIREPM  TF315-80 TD315-80 UAMPL    TMF-BRID
 TMD-BRID TF-BASIC TD-ENVI  TTF-RIB2 TTD-LUG2 INFLAHOS CAB-WIDE
 L2H2     MSW-BAS  CABS-MEC CTILTP-M CPAN-MF  FMUD-AS  USIDESTP
 CURT-WB  UAWINDS  STW-D450 WLIFT-EB URHATCH  GLAS-UNT UAWINDR 
 CABSIGN  GR-STD   LOCK-MRP REFL-EC  DPAN-IAT UMATINS  MIRR12C1
 MIR-ELHE AMIR-WB  UAMIRF   TRIM-TX1 USPLIMS  UARMREST CITC-IBL
 ROS-IL   BUNK70T  UROOFSIG DST-CF1  UFMAT    PST-STD2 UACCBRKT
 UREFS    SEAT-VOL LANG-TUR PUBL-TUR CERT-EC  CU-MCC   SERVM-B 
 BUMP-P   TOWF-NO1 UEXTRIM  BEDNET   USAFETYB RSH-RACA SLCP-LUX
 SUNV-URL TD-BAS   USCRS    AD-ROOF  AD-SIDEL UADCHAS  UOBSTOR 
 SAFEKIT  ETSB-S   UREFRIG  FIREXT3S PH-CAB   UFLARE   AMIR-S30
 ISUNV-S  ANT-CBPK SPK-DASH UGUARD   GUARD-HL UGUARDW  UEBHEAT 
 UBUPALAR PTOTRA-S UPTOF    TBH-COL  UCOOLPTO BRAND-V  UHOSEH  
 TEC-DET  TBC-EC   TREL7-7  SIGN-L   TLB-BAS  XINS-CAB FWP0575 
 5WM-LPRO 5WH200   KPSIZE50 5WT-GF   RAMP-MED UTOWMBR  UTOWR   
 SPWCA-B  SWCP-T   SPWT-F   UTFSEAL  UTDSEAL  UBUMPSP  RFLI-F  
 UOFFICE  URFCAR   FMUDE-B  RMUDF-AS RFEND-B  JACK-15T TOOLKIT 
 WHCHOCK2 RDECK    UTAIL    ULSS     UHPG     UAMSO    UTRUSTP 
 ULUBCENT WARR300  UTBL     UTBR     EBS-MED  UBUPMON  USBPREDS
 UEOBD    TC-DISTR UCOFMAK  ULCHF    UWRNLAMP USBPREPS UDFSUB  
 MFACTBEL EU3      PROPCALC 3500MM   FROCALC  8EE      1103WHIT
 WB3700   PAICS-B  STG-LR   UENG-GEN FACT-BEL

But the data returned into my excel sheet is like this :

04-TLV   FM 42T B MAT-GREY UXFUEL   ULADDER  USPOTP   UDECALTP
 FFL1295  SPWCD-EC UBULBKIT ULAMPIN  UGAUGETP UCHAINS  VERSION2
 EMBL-MO  WSTUD-S  UEGR     TYPE-FM  UTRAPACK ULOADIND 4*2     
 DASH-BLU CABPT-R1 TRACTOR  RC-ROUGH GCW56.0  CONC-BAS UALARMB 
 ENG-VE13 VH4.0    UWARVEST UBUNKBOX UAIRBAG  EXHP-SAC SUNV-SMO
 UAPF     USIGNSWC UCOMEQ   SUPH-TEX SEATBRI  AUXSW-6  WRITEPAD
 USIGNS   TELECARD UFUFIWH  STWPOS-L RAA11    DIMPLATE UPAXLE  
 VW2600   MATT-PRE FA-HIGH  FRAX-UNI FAL7.1   FATYPE71 FAP3040 
 FAA10    UTAXLE   RAL13    RAD-A4   RAP6740  LUGOP-BS INST-HIG
 AUD-BAS  UADR     VERS-BAS CHH-STD  UBSR     URSTS    D13A400 
 VOLENG   ETOR2040 CHOSE-RU EBR-VEB  BUGNET   RADI-NAR VAL-BAS3
 WTD-DUAL UWCAP    CLUT-BAS COOLC48  USPEEDDU SPEED90  CRUISEC 
 FAN-VISE UFUELFP  AIRIN-HI FUELSEC2 FUELTFIL AF-E     ULFUEL  
 RFUEL530 FUELTS71 TNK-SING FTANK-AL FCAP-L   MUF-HOR  EXD-LEFT
 EXSH-ST  UEXSTACK UEAS     EM-EC01  NR-80EC  ACL1ST   URPLCR  
 ENGPROT  UPSCOOL  24V      TRANSF-H UTRACON  UTABS    UACC    
 UPHONE   LOWB-STD UFLASHL  HL-ASYMR DETECT-S HORN-ELS USWS    
 HORN-JER UELCEPK  BBOX-L   BBOXC-BA 2BATT225 UHOOKSC  UFMS    
 UADTL    URAG     TWEETER  URTOLL   EST-AID  TL-BAS   MAINSW-M
 FOGL-WC  DRIVL2EC FUP      UHLADJ   HL-CLEAN IMMOBIL  UIDLAMP 
 MARKL-SR UALTTR   UDOUTLET RLIGHT-W UWPREBOC WL-TA1W  UWARNLIG
 SPG-KM   ESUNV2P  ASCOP120 UPSCAT   SBD-BLAC SBP-BLAC UEPTT   
 CIRCP-F  TEMP-AMB TEMP-TRA UGAUGEAM 24ALT-HB SI-GRAF  1DAY-STD
 CALI-EC  DIFL-TUR DISL-NUM UTIS     UKEYB    HL-BASIC T-PFLAT 
 OILS-PL  BATTD128 RSAP-BAS TRAP-BAS UEBRAS   URSTL    TURB-B  
 SBCC-B   ADH-HIGH TBH-COL  UCOOLPTO BRAND-V  UHOSEH  
 TEC-DET  TBC-EC   TREL7-7  SIGN-L   TLB-BAS  XINS-CAB FWP0575 
 5WM-LPRO 5WH200   KPSIZE50 5WT-GF   RAMP-MED UTOWMBR  UTOWR   
 SPWCA-B  SWCP-T   SPWT-F   UTFSEAL  UTDSEAL  UBUMPSP  RFLI-F  
 UOFFICE  URFCAR   FMUDE-B  RMUDF-AS RFEND-B  JACK-15T TOOLKIT 
 WHCHOCK2

So as you may realized the whole list couldn't be imported into Excel sheet. I tried every option in Data Range Properties but none of them worked. The web source i get this data is http://edb.volvo.net/cgi-bin/wis2/v...&f2=07&f3=1166&funcflag=0&varfam=0&limitfunc= but you need to have login over a VPN Client and supplied password so you probably wont be able to see the page.

You will make me very happy if you can suggest me a working solution.

Regards.