i have a json file, which contains KV pairs like below.

{
"app1_ds1_ds_jndi": "value1",
"app1_ds1_ds_url": "value2",
"app1_ds1_ds_useri": "value3",
"app1_ds1_ds_pwd": "value4",


"app1_ds2_ds_jndi": "value5",
"app1_ds2_ds_url": "value6",
"app1_ds2_ds_user": "value7",
"app1_ds2_ds_pwd": "value8",


"app2_ds1_ds_jndi": "value9",
"app2_ds1_ds_url": "value10",
"app2_ds1_ds_user": "value11",
"app2_ds1_ds_pwd": "value12",

}


I want to parse the above file to grep for all app1 datasources, ignoring other apps like app2, app3 ..etc., and construct an array of hashes in ruby like below.




[{jndiname: "value1",  url_name:"value2" user_name: "value3", Password:"value4"},
{jndiname: "value5",  url_name:"value6" user_name: "value7", Password:"value8"}
]

I have the following json:

{
"count":2,
"page":1,
"pageSize":2,
"students":[{"forename":"Joe","surname":"Bloggs"},{"forename":"John","surname":"Doe"}],
"totalCount":2,
"totalPages":1
}

Select all Open in new window

How can I alter this in PHP to just get the following:

{
[{"forename":"Joe","surname":"Bloggs"},{"forename":"John","surname":"Doe"}]
}

Select all Open in new window

Thank you in advance

This question will likely expose my level of understanding of JQuery but I am getting this error:

Uncaught TypeError: $(...).marquee is not a function
    at results_scrollx.asp?event_type=5&event_id=794&race_id=1382:62

On this page: https://www.gopherstateevents.com/results/fitness_events/results_scrollx.asp?event_type=5&event_id=794&race_id=1382

I assume there is something structurally wrong but I haven't found it yet...  Any help would be much appreciated.

I am trying to make a request to Google Cloud NLP API to obtain sentiment analysis for a piece of text. I used Postman to design the correct request, and I was able to get a valid response using Postman. However, when I try to make the same request from Swift, it gives me an error. The error and code snippet used to make the request is shown below.

func sendAPIRequest(with text: String){

    print("Text: ", text)
    let jsonRequest = [
        [
        "document":[
            "type":"PLAIN_TEXT",
            "language": "EN",
            "content":"'Lawrence of Arabia' is a highly rated film biography about British Lieutenant T. E. Lawrence. Peter O'Toole plays Lawrence in the film."
        ],
        "encodingType":"UTF8"
    ]
        ]

    let jsonObject = JSON(jsonRequest)


    let headers: HTTPHeaders = [
        "X-Ios-Bundle-Identifier": "\(Bundle.main.bundleIdentifier ?? "") ",
        "Content-Type": "application/json"
    ]
    let APIRequest = Alamofire.request("https://language.googleapis.com/v1/documents:analyzeSentiment?key=\(gCloudAPIKey)", method: .post , parameters: jsonRequest as? [String: Any], encoding: JSONEncoding.default , headers: headers).responseJSON { (response) in
        print(response)
        if let json = response.result.value {
            print("JSON: \(json)")
        }
    }

Select all Open in new window

Error:

JSON: {
error =     {
    code = 400;
    details =         (
                    {
            "@type" = "type.googleapis.com/google.rpc.BadRequest";
            fieldViolations =                 (
                                    {
                    description = "Must have some text content to annotate.";
                    field = "document.content";
                }
            );
        }
    );
    message = "One of content, or gcs_content_uri must be set.";
    status = "INVALID_ARGUMENT";
};
}

Select all Open in new window

I know similar questions to this have been asked before but I'm having difficulty implementing the solutions.  I have a very simple access database which uses an API to get outside data.  I am getting the correct data now, but the response is JSON that I need to parse into a table and/or update rates in an existing table.  Essentially I am trying to do the same thing as in this question:

https://www.experts-exchange.com/questions/28952370/Parse-JSON-with-VBA-Access-2010.html

I have no idea how to implement this though.  I am a complete novice at JSON and using an API.  Can anyone give me some pointers in laymans terms on how to implement this?  I need to know what code to put into a module, and how to call it.  Once I see it working Ill be able to run with it I think, but right now Im very confused.

Hi there,

Can anyone help me for below query.
How to hit POST API through TDL language which can send data in JSON format from Tally and get response.  Please send us complete code for this.

      
I am using below code but this is not working.

[#Menu: Gateway of tally]
      Add: Item: send data : Call: Senddata
      
[Function: Senddata]
            
      00      :      Walk            : SendDatacoll      
      10      :      End Walk
      20      :      Return
      
[Collection      : senddatacoll]
      Remote URL            : "API url"
      RemoteRequest        : RepsalesVch       : UTF8
      ClientOnly             : Yes
      KeepSource      : yes
      JSON Object            : yes
      
      
      
[Report      : RepsalesVch]
      Form: RepsalesVch
      
[Form :      RepsalesVch]
      Part      : RepsalesVch Body
      Button      : Export button
      JSONTag      : "Report"
 
                        
[Part: RepsalesVch Body]
      JSONTag            : "Body"
      Line            :  RepsalesVchdetails
      
[Line:      RepsalesVchdetails ]
            Field            : ParCDBId, Partnername  , ActiveStatus  
            JSONTag            : "Details"


[Field:      ParCDBId ]
      Set as             :   "NDL002"
      JSONTag       :       "ID"
      
      
[Field                  :      Partnername ]
      Set as             :       "ABC PVT LTD"
      JSONTag            :      "ITEMNAME"
      
      
[Field                  :      ActiveStatus ]
      Set as             :       "1"
      JSONTag            :      "Active"
      

Regards
Pushpa Adhikari

I have created a LINQ to return data from SQL server in JSON format which contains nested values.
Attach the code and output, the JSON is showing duplicate values for FieldID:6

var query =  from g in entity.ConfigSearchFieldGroupings
                         join f in entity.ConfigSearchFieldGroupingFields
                         on g.GroupingID equals f.GroupingID
                         join d in entity.ConfigDataFields
                         on f.FieldID equals d.FieldID
                         join ss in entity.ConfigSelections
                         on d.FieldID equals ss.FieldID into t
                         from rt in t.DefaultIfEmpty()
                         join s in entity.ConfigSourceSystems
                         on d.SystemCode equals s.SystemCode
                         where g.IsActive == true
                         && d.IsActive == true
                         && s.IsActive == true
                         && g.GroupingID == siGroupingID
                         && d.IsSearchable == true
                         select new
                         {
                             g.GroupingName,
                             f.FieldID,
                             d.FieldName,
                             d.FieldText,
                             d.FieldDescription,
                             d.FieldCategory,
                             d.FieldDataType,
                             d.FieldLength,
                             

Select all Open in new window

…

I'm using json2.asp from:  https://github.com/nagaozen/asp-xtreme-evolution.

Here is a sample string:
[
{"Product Line":"B5","Model":"B521432CSSK","length":"14","Column1":"14'x5" Channel Buggy Hauler","Dealer Cost":"$2,685.00"},
{"Product Line":"B5","Model":"B521632CSSK","length":"16","Column1":"16'x5" Channel Buggy Hauler","Dealer Cost":"$2,684.00"},
{"Product Line":"B5","Model":"B521832CSSK","length":"18","Column1":"18'x5" Channel Buggy Hauler","Dealer Cost":"$2,719.00"}
]

When I run the following:
dim info : set info = JSON.parse(join(array(ProductFeed)))
for each key in info.keys()
Response.write key
next
set info = nothing

I get numbers. If I remove the brackets at the beginning/end of the string, I get "Product Line", "Model", etc. - but I only get the first row of the string.

I need to loop through the whole JSON string, get the name and value pair, process, go to the next row....

Any help would be appreciated.

Hello,
Im trying to translate this code from https://securionpay.com/docs/api#checkout-request-sign.

EXAMPLE SIGNING


export checkout_request='{"charge":{"amount":499,"currency":"EUR"}}'
export signature=`echo -n "$checkout_request" | openssl dgst -sha256 -hmac 'pr_test_tXHm9qV9qV9bjIRHcQr9PLPa' | sed 's/^.* //'`
echo -n "$signature|$checkout_request" | base64
        

EXAMPLE SIGNED CHECKOUT REQUEST


Y2Y5Y2UyZDgzMzFjNTMxZjgzODlhNjE2YTE4Zjk1NzhjMTM0Yjc4NGRhYjVjYjdlNGI1OTY0ZTc3OTBmMTczY3x7ImNoYXJnZSI6eyJhbW91bnQiOjQ5OSwiY3VycmVuY3kiOiJFVVIifX0=
				

Select all Open in new window

to Ruby on Rails

I ended with

       
 checkout_request='{"charge":{"amount":5,"currency":"EUR","capture":true}}'
 secret_key = 'sk_test'
 @signature = Base64.urlsafe_encode64(OpenSSL::HMAC.hexdigest('sha256', checkout_request, secret_key) + "|" + checkout_request)

Select all Open in new window

which isn't valid and its not exacly translation of the script.

When i test shell version with my secret key it works.
I tried Base64.urlsafe_encode64, encode64, strict_encode65, I tried digest instead of hexdigest. All kinds of way because I desperatly can't make it work. I think its about checkout_request data because it translates to this
 

2.5.0 :001 > '{"charge":{"amount":5,"currency":"EUR","capture":true}}'
 => "{\"charge\":{\"amount\":5,\"currency\":\"EUR\",\"capture\":true}}" 

Select all Open in new window

and therefore signature is created with `\` before quote

question on stackoverflow: https://stackoverflow.com/questions/51506282/json-and-generating-signature

I'm returning data from an ajax request as json.
I have two queries that I execute when the request is made and the result is being sent back together as one variable ($vehicle).
Something like this:

My first query gets the various customer service reps for a given dealer using:

$all_csr = DB::table('users')
                  ->join('dealerships', 'users.dealership_id', '=', 'dealerships.id')
                  ->select(DB::raw('CONCAT(users.first_name, " ", users.last_name) AS csr'),'users.id')
                  
            ->where(function ($query) use($dealership) {
                  $query
                  ->where('users.dealership_id', $dealership->id)
                  ->whereNull('users.deleted_at')
                  ->where('users.banned', 0)
                  ->where('users.position_id', 'service_advisor');
                  })
            ->orWhere(function($query) use($dealer) {
                  $query
                  ->where('users.dealership_id', $dealer)
                  ->whereNull('users.deleted_at')
                  ->where('users.banned', 0)
                  ->where('users.position_id', 'service_manager');      
                  })
            ->orWhere(function($query) use($dealer) {
                  $query
                  ->where('users.dealership_id', $dealer)
                  ->whereNull('users.deleted_at')
                  ->where('users.banned', 0)
                  ->where('users.position_id', 'fixed_operations_manager');      
                  })
            ->get();

A second query is being returned from an API as xml for a given vehicle and I process something like this into a variable named $vehicle:

$obj = SimpleXML_Load_String($xml);

$vehicle = $obj->s_Body->RepairOrderContactVehicleGetResponse->Items->RepairOrderContactVehicle;

Lastly so I can …

I start with the following codes with mvc/json/c#
and I just want to know how to get the following items
Or there is easier way to get everything inside of json file. that will be great.


rating
open now
weekday text
viewport
photos height
photos html_attributions


https://developers.google.com/places/web-service/search

WebClient wc = new WebClient();
string jsonStr = wc.DownloadString("https://maps.googleapis.com/maps/api/place/nearbysearch/json?location=37.753,-122.443&radius=10000&type=rv_park&key=AIzaSyCietasdfasdfasdfasdfxzD65Uc19X6DgrJFumdi-nCZYSHjg");
GooglePlacesResponse gpr = (GooglePlacesResponse)JsonConvert.DeserializeObject<GooglePlacesResponse>(jsonStr);
Response.Write(gpr.status + "<br><br>");

Select all Open in new window

Trying to fetch ID in response that is stored in database of Post request. In table ID is autogenerated. tried one code but it is not working. Please suggest.

    public HttpResponseMessage Post(List<DelegateTable> delegatetable)
        {
            try
            {
                using (ShowContext delegateContext = new ShowContext())
                {
                    DelegateTable delegates = new DelegateTable();
                    List<DelegateTable> list1 = new List<DelegateTable>();
                  
                    foreach (DelegateTable item in delegatetable)
                    {
                       
                        delegates.Salutation__c = item.Salutation__c;
                        delegates.First_Name__c = item.First_Name__c;
                        delegates.Last_Name__c = item.Last_Name__c;
                        delegates.Account_Name__c = item.Account_Name__c;
                        delegates.Contact_Email__c = item.Contact_Email__c;
                        delegates.Category__c = item.Category__c;
                        delegates.Conference_Type__c = item.Conference_Type__c;
                        delegates.Conference_Selection__c = item.Conference_Selection__c;
                        delegates.Payment_Status_Interface__c = item.Payment_Status_Interface__c;
                        delegates.Barcode__c = item.Barcode__c;
                        delegateContext.delegates.Add(delegates);
                       
            

Select all Open in new window

…

Hi guys,

I am curious about the benefits of using SDKs. Personally, I prefer avoiding third-party libraries, especially if I don’t see any benefits of having serialized JSON output in class models (I have found this to be the case when using JavaScript, NodeJS, PHP, Python, and other functional programming languages). When using serialized JSON models in Java, C++, C#, and ActionScript, I observed a decline in performance.

However, I am aware that companies including Google, Amazon, Salesforce, etc are generating REST API services for SDK code for developers to consume.
 
What have you found to be the main pros/cons of using SDK, and what are your personal preferences regarding which REST SDK is best for various languages?

Best,
David