0 Replies Latest reply on Feb 27, 2017 2:55 AM by Ghouse Shaik

    Tableau Web Data Connector issue on internal json api

    Ghouse Shaik

      Hi All,

       

      I created a web data connector which consists the files twitter1.html & twitter1.js.

       

      In twitter1.js, i used a internal local api url i.e., http://localhost/praveen/Twitter/twitter-api-php-master/index.php   which gives the below json data.

       

      [{"created_at":"Tue Jan 12 08:35:48 +0000 2016","id":686828916334542849,"id_str":"686828916334542849","text":"Hello IMO Developing Team.I didn't find any imo app for windowS phone. Can you pleaSe releaSe the IMO app in Windows mobiles also. ThankS...","truncated":false,"entities":{"hashtags":[],"symbols":[],"user_mentions":[],"urls":[]},"source":"\u003ca href=\"http:\/\/twitter.com\" rel=\"nofollow\"\u003eTwitter Web Client\u003c\/a\u003e","in_reply_to_status_id":null,"in_reply_to_status_id_str":null,"in_reply_to_user_id":null,"in_reply_to_user_id_str":null,"in_reply_to_screen_name":null,"user":{"id":2804907529,"id_str":"2804907529","name":"Ghouse Shaik","screen_name":"ghouse06shaik","location":"Kingdom of Saudi Arabia","description":"","url":null,"entities":{"description":{"urls":[]}},"protected":false,"followers_count":0,"friends_count":2,"listed_count":0,"created_at":"Fri Sep 12 03:46:48 +0000 2014","favourites_count":0,"utc_offset":null,"time_zone":null,"geo_enabled":false,"verified":false,"statuses_count":2,"lang":"en","contributors_enabled":false,"is_translator":false,"is_translation_enabled":false,"profile_background_color":"C0DEED","profile_background_image_url":"http:\/\/abs.twimg.com\/images\/themes\/theme1\/bg.png","profile_background_image_url_https":"https:\/\/abs.twimg.com\/images\/themes\/theme1\/bg.png","profile_background_tile":false,"profile_image_url":"http:\/\/abs.twimg.com\/sticky\/default_profile_images\/default_profile_4_normal.png","profile_image_url_https":"https:\/\/abs.twimg.com\/sticky\/default_profile_images\/default_profile_4_normal.png","profile_link_color":"1DA1F2","profile_sidebar_border_color":"C0DEED","profile_sidebar_fill_color":"DDEEF6","profile_text_color":"333333","profile_use_background_image":true,"has_extended_profile":true,"default_profile":true,"default_profile_image":true,"following":false,"follow_request_sent":false,"notifications":false,"translator_type":"none"},"geo":null,"coordinates":null,"place":null,"contributors":null,"is_quote_status":false,"retweet_count":0,"favorite_count":0,"favorited":false,"retweeted":false,"lang":"en"},{"created_at":"Sat Aug 01 13:24:50 +0000 2015","id":627470042595229696,"id_str":"627470042595229696","text":"i'm trying to get a reply from my favourite @urstrulyMahesh through #AskSrimanthudu \nBt i think i won't get success...","truncated":false,"entities":{"hashtags":[{"text":"AskSrimanthudu","indices":[69,84]}],"symbols":[],"user_mentions":[{"screen_name":"urstrulyMahesh","name":"Mahesh Babu","id":129786468,"id_str":"129786468","indices":[44,59]}],"urls":[]},"source":"\u003ca href=\"http:\/\/twitter.com\" rel=\"nofollow\"\u003eTwitter Web Client\u003c\/a\u003e","in_reply_to_status_id":null,"in_reply_to_status_id_str":null,"in_reply_to_user_id":null,"in_reply_to_user_id_str":null,"in_reply_to_screen_name":null,"user":{"id":2804907529,"id_str":"2804907529","name":"Ghouse Shaik","screen_name":"ghouse06shaik","location":"Kingdom of Saudi Arabia","description":"","url":null,"entities":{"description":{"urls":[]}},"protected":false,"followers_count":0,"friends_count":2,"listed_count":0,"created_at":"Fri Sep 12 03:46:48 +0000 2014","favourites_count":0,"utc_offset":null,"time_zone":null,"geo_enabled":false,"verified":false,"statuses_count":2,"lang":"en","contributors_enabled":false,"is_translator":false,"is_translation_enabled":false,"profile_background_color":"C0DEED","profile_background_image_url":"http:\/\/abs.twimg.com\/images\/themes\/theme1\/bg.png","profile_background_image_url_https":"https:\/\/abs.twimg.com\/images\/themes\/theme1\/bg.png","profile_background_tile":false,"profile_image_url":"http:\/\/abs.twimg.com\/sticky\/default_profile_images\/default_profile_4_normal.png","profile_image_url_https":"https:\/\/abs.twimg.com\/sticky\/default_profile_images\/default_profile_4_normal.png","profile_link_color":"1DA1F2","profile_sidebar_border_color":"C0DEED","profile_sidebar_fill_color":"DDEEF6","profile_text_color":"333333","profile_use_background_image":true,"has_extended_profile":true,"default_profile":true,"default_profile_image":true,"following":false,"follow_request_sent":false,"notifications":false,"translator_type":"none"},"geo":null,"coordinates":null,"place":null,"contributors":null,"is_quote_status":false,"retweet_count":0,"favorite_count":0,"favorited":false,"retweeted":false,"lang":"en"}]

       

      All though working fine, but when i click on 'Update Now' option in Tableau Desktop. It loads only but not pulling any data on Tableau end.

       

      Thanks in Advance.

       

      Regards by,

      Ghouse Shaik.