[SOLVED] How to update WF User status using REST WebServices from webfocus
Hi all I am trying to update WF User status using below REST Web Services metadata. but i got (FOC42229) ENTITY 'nbsp' IS UNDEFINED error. Could any one guide me how to update WF User details from webfocus.
TABLE FILE LOGON
PRINT
ENTRY.VALUE
RETURNCODE NOPRINT
RETURNDESC NOPRINT
IF USERNAME EQ 'admin'
IF PASSWORD EQ 'admin'
IF ENTRY.KEY EQ 'IBI_CSRF_Token_Value'
ON TABLE HOLD AS CSRFTOKEN
END
-RUN
-READ CSRFTOKEN &&CSRFTOKEN.A100.
-TYPE &&CSRFTOKEN
TABLE FILE UPDATE_WFUSER
PRINT
RETURNCODE
RETURNDESC
IF CSRF_TOKEN EQ '&&CSRFTOKEN'
WHERE IBFS_NAME EQ 'test_login'
WHERE IBFS_EMAIL EQ 'Test_login@wls.com'
WHERE IBFS_DESCRIPTION EQ 'Test_login'
WHERE IBFS_STATUS EQ 'INACTIVE'
ON TABLE HOLD AS DELUSER FORMAT ALPHA
END
-RUN
This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8.2.01,windows 8,All Output Format
August 29, 2017, 05:36 PM
Waz
Hi Sowthri,
Welcome to the forum.
According to the fex, you are reading &&CSRFTOKEN from a hold file, then using it in the next table.
What is the contents of &&CSRFTOKEN ?
My first thought about your error is that an   may be in the read variable.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
August 31, 2017, 02:46 AM
Sowthri
Thanks WAZ, We are geting value for &&CSRFTOKEN from hold file and it's an alphanumeric value.After using in UPDATE_WFUSER table flowing Error occurs.
TABLE FILE LOGON
PRINT
ENTRY.VALUE
RETURNCODE NOPRINT
RETURNDESC NOPRINT
IF USERNAME EQ 'admin'
IF PASSWORD EQ 'admin'
IF ENTRY.KEY EQ 'IBI_CSRF_Token_Value'
ON TABLE HOLD AS CSRFTOKEN
END
-RUN
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
-READ CSRFTOKEN &&CSRFTOKEN.A100.
-SET &&CSRFTOKEN = TRUNCATE(d6e4c76ea3ca48b622a52aa0bb399dbd );
-TYPE d6e4c76ea3ca48b622a52aa0bb399dbd
d6e4c76ea3ca48b622a52aa0bb399dbd
TABLE FILE UPDATE_WFUSER
PRINT RETURNCODE RETURNDESC
IF CSRF_TOKEN EQ 'd6e4c76ea3ca48b622a52aa0bb399dbd'
WHERE DESCRIPTION EQ 'test_login'
WHERE EMAIL EQ 'Test_login@test.com'
WHERE NAME EQ 'INACTIVE'
ON TABLE HOLD AS DELUSER FORMAT ALPHA
END
-RUN
(FOC42229) ENTITY 'nbsp' IS UNDEFINED
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
WebFOCUS 8.2.01,windows 8,All Output Format
August 31, 2017, 02:44 PM
FP Mod Chuck
Hi Sowthri
First of all welcome to Focal Point! I reached out to the product manager about this post and he recommended you open a case with techsupport. He suspects this is a bug.
Thanks
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
August 31, 2017, 03:04 PM
Efrem
Not a bug in the software. At first glance, looks like you're missing some stuff in the Master.
I'll try and look at this tomorrow.
August 31, 2017, 03:32 PM
Efrem
I looked at your Master. Doesn't look like the ALIASes for WebFOCUS RESTful Web Services.
It looks like your trying to integrate with some other WebFOCUS integration.
I'll prepare an example calling WebFOCUS RESTful Web Services and Post it when complete.
updateuser.fex: TABLE FILE LOGON PRINT ENTRY.VALUE RETURNCODE NOPRINT RETURNDESC NOPRINT IF USERNAME EQ 'admin' IF PASSWORD EQ 'admin' IF ENTRY.KEY EQ 'IBI_CSRF_Token_Value' ON TABLE HOLD AS CSRFTOKEN END -RUN
TABLE FILE ADDUSER PRINT ADDUSER.RESPONSE.RETURNCODE AS 'Return Code' ADDUSER.RESPONSE.RETURNDESC AS 'Return Description' HEADING "Update a User" WHERE IBIRS_PATH EQ '/SSYS/USERS/test_login' WHERE DESCRIPTION EQ 'test_login' WHERE EMAIL EQ 'Test_login@wls.com' WHERE NAME EQ 'INACTIVE' WHERE IBIRS_REPLACE EQ 'true' WHERE CSRF_TOKEN EQ '&&CSRFTOKEN' ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ ENDSTYLE
September 01, 2017, 03:16 AM
Sowthri
Thanks Efrem, It's working good. Thanks for your help. Cloud you please share Master file for change password and guide us how to update the password for a wf user.
WebFOCUS 8.2.01,windows 8,All Output Format
September 01, 2017, 05:58 AM
Efrem
I think you should mark this as solved and open a new topic for Changing a Password.